DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  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 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.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.