Displaying the Row Number in a SELECT Query with SQL Server 2005

SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row.

More details