That is correct and you can also dynamically do that based on your
query.

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.
com:80/support/kb/articles/q186/1/33.asp&NoWebContent=1

John

-----Original Message-----
From: Balvinder [mailto:[Email Address Removed]
Sent: Friday, August 29, 2003 2:11 AM
To: LazyDBA.com Discussion
Subject: RE: Row number

No there is No rownum available in SQL SERVER.

Regards

Banga Balvinder

-----Original Message-----
From: Kumar [mailto:[Email Address Removed] Friday, August 29, 2003 2:31 PM
To: LazyDBA.com Discussion
Subject: Row number


Dear Friends,

Is there a rownum in SQL server like Oracle?

Thanks for replying

--kumar

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page