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

Thread: ROWNUM in MSSQL server

  1. #1
    Join Date
    Feb 2001
    Posts
    100

    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
    Location
    Pittsburgh, PA
    Posts
    3,968

    Lightbulb

    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