ROWNUM in MSSQL server

[Hakimca]

Hi all,

What's the equivalent of the pseudo-column ROWNUM in MSSQL Server.


Thanks in advance

[gandolf989]

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.