Getting Row Number

• Bob Baisc

  SSC Enthusiast

  Points: 123

  More actions

  September 21, 2005 at 6:04 pm

  #187813

  Hi,

  Does anyone know if SQL Server has a @@ROWID variable or function that gives me the row number the query is on?

  For exampe if I select 5 quiries from an employee table:

  SELECT FirstName, LastName, Age, @@ROWID

  it gives me

  John, Smith, 40, 1

  Jane, Doe, 34, 2

  Josh, Cooper, 44, 3

  keeps incrementing automatically when displaying each row

  Bob

• philcart

  SSC-Forever

  Points: 47797

  More actions

  September 21, 2005 at 7:09 pm

  #592053

  Unfortunately SQL 2000 does not have a row number function, you'll have to wait for SQL 2005 for that

  In the meantime, take a look at these articles and choose the best workaround that suits,

  http://www.aspfaq.com/show.asp?id=2427

  http://databasejournal.com/features/mssql/article.php/10894_2244821_1

   

  --------------------
  Colt 45 - the original point and click interface