DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ROWNUM in MSSQL server

  1. 10-23-2002, 04:14 PM #1
    Hakimca
    Hakimca is offline Member
    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
    Reply With Quote Reply With Quote
  2. 10-23-2002, 04:23 PM #2
    gandolf989's Avatar
    gandolf989
    gandolf989 is offline Senior Advisor
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166

    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width