Generate auto row number for a table

SELECT ROW_NUMBER() OVER(ORDER BY [col_1]) as RowNumber,
COUNT([col_1]) OVER () AS RecordCount,* FROM TableName

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

Mukund Thakker

Software Developer (Senior)

India

Member

Follow on Twitter

Software Developer
MCTS - .NET Framework 4.0, Web Applications

Blog : http://thakkermukund.wordpress.com
Twitter@thakkermukund

Don't code today, what you can't debug tomorrow!
Everything makes sense in someone's mind

Article Top

Poor

Excellent

Add a reason or comment to your vote: x
Votes of 3 or less require a comment

Alternative to Generate auto row number for a table

SELECT ROW_NUMBER() OVER(ORDER BY [col_1]) as RowNumber,COUNT([col_1]) OVER () AS RecordCount,* FROM TableName

Type	Tip/Trick
Licence	CPOL
First Posted	28 Sep 2011
Views	1,023
Bookmarked	0 times

ASP.NETSQL-Server

		9,886,267 members (38,863 online) Visit CodeProject.TV Discuss CodeProject.TV Sign in Email Password Forgot your password? Sign in using

Generate auto row number for a table

License

About the Author

Comments and Discussions