Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 rownum

Author  Topic 

dasu
Posting Yak Master

104 Posts

Posted - 2004-09-24 : 01:59:09
can nu tell me the rownum(oracle) equavalent in mssql server
please

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2004-09-24 : 02:48:52
There really isn't one.
You can emulate it by inserting your set into a temp table with an identity column, but there is usually a more elegant, more "sql server" way of doing things.



Damian
Go to Top of Page
   

- Advertisement -