ROWNUM in MSSQL server Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ROWNUM in MSSQL server

  1. #1
    Join Date
    Feb 2001

    Red face ROWNUM in MSSQL server

    Hi all,

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

    Thanks in advance

  2. #2
    Join Date
    Nov 2000
    Pittsburgh, PA


    Have you thought about looking at a Sql Server site instead of an Oracle site? I sometimes look at

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width