Database

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()

SELECT id, MAX(DateUpdated)
FROM MyTable
GROUP BY ID

SELECT id, DateUpdated,OtherColumns
FROM MyTable 
INNER JOIN
(
 SELECT id, MAX(DateUpdated) as MostRecentlyUpdated
 FROM MyTable
 GROUP BY ID
) MostRecentMyTable
ON MyTable.Id = MostRecentMyTable.id
AND MyTable.DateUpdated = MostRecentMyTable.MostRecentlyUpdated

<br />
select distinct id,<br />
(select top 1 t1.dateupdated from MyTable as t1 where t1.id = MyTable.id order by t1.dateupdated asc),<br />
restoftable from MyTable