Database

CREATE FUNCTION MyFunction()
RETURNS @tbl TABLE(COLUMN_NAME VARCHAR(50))
AS
SELECT 
 'A'
INTO @tbl
FROM someTable

astrovirgin wrote:

But it is not working. Is this a right query or some mistakes are there.

System.Data.DataTable result = null ;

try
{
    result = this.ExecuteReader
    (
        string.Format
        (
            "SELECT * FROM [{0}] WHERE 0=1"
        ,
            TableName
        )
    ).GetSchemaTable() ;

    result.TableName = "Columns" ;

Ashfield wrote:

the OP did specify sql server

declare @milliSecNow int
set @milliSecNow = datepart(Ms, getdate())
print milliSecNow

select
    top 100000 *
into
    #randByDate
from
    myTable
where
    recv_date between '2007-01-01' AND '2007-12-31'
--order by
--    rand(@milliSecNow)

select
    top 10 firstColumn
from
    #randByDate
order by
    rand(@milliSecNow)

drop table #randByDate

select
top 10 *
from
myTable
where
dateReceived between @startDate and @endDate
order by newid()