Hi all,
What's the equivalent of the pseudo-column ROWNUM in MSSQL Server.
Thanks in advance
Printable View
Hi all,
What's the equivalent of the pseudo-column ROWNUM in MSSQL Server.
Thanks in advance
Have you thought about looking at a Sql Server site instead of an Oracle site? I sometimes look at www.sqlteam.com.
I don't know what the equivelent of RowNum is, however, you can always add an identity column to a table and use that as a rownumber field. you will have to recreate the table and reinsert all of the records into that table.