Get RowID on select query

Hi,

 I'm working with Transact SQL 2005 and I'm trying to do a query with the the Row Index. But, I don't have the function Row_Index() or RowIndex().

What is the equivalent of Row_Index or Row_Number in Transact SQL 2005?

Thank's
Albator666Asked:
Who is Participating?
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
You have ROW_NUMBER() function in SQL Server 2005..

http://www.databasejournal.com/features/mssql/article.php/3572301/RowNumber-function-in-SQL-Server-2005.htm

Kindly let me know if you meant any other functions..
0
 
BryanMICommented:
The question he asked was answered appropriately and correctly by an expert.  That person deserves the points for the answer.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Thanks BryanMI and Albator666.
Wishing you both Happy Holidays..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.