Get RowID on select query


 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?

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

Kindly let me know if you meant any other functions..
The question he asked was answered appropriately and correctly by an expert.  That person deserves the points for the answer.
Raja Jegan RSQL Server DBA & ArchitectCommented:
Thanks BryanMI and Albator666.
Wishing you both Happy Holidays..
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.