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

[EDN Admin]

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.
http://feedads.g.doubleclick.net/~a/2EhrpNWCuluR11ReEHFYwGgEtvs/0/da <img src="http://feedads.g.doubleclick.net/~a/2EhrpNWCuluR11ReEHFYwGgEtvs/0/di" border="0" ismap="true </img> <br/>
http://feedads.g.doubleclick.net/~a/2EhrpNWCuluR11ReEHFYwGgEtvs/1/da <img src="http://feedads.g.doubleclick.net/~a/2EhrpNWCuluR11ReEHFYwGgEtvs/1/di" border="0" ismap="true </img> <img src="http://feeds.feedburner.com/~r/DevxRecentTipsFeed/~4/On9dFw2Tqc8" height="1" width="1"/>

View the full article