Number of different ways to get total number of rows from tables

Pranay Rana

Rate me:

4.57/5 (20 votes)

21 Jun 2010CPOL

72.5K

Getting a SQL Server RowCount Without doing a Table Scan

No downloads associated with this content

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

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

Written By

Pranay Rana

Software Developer (Senior)

India

Microsoft C# MVP (12-13)

Hey, I am Pranay Rana, working as a Team Leadin MNC. Web development in Asp.Net with C# and MS sql server are the experience tools that I have had for the past 5.5 years now.

For me def. of programming is : Programming is something that you do once and that get used by multiple for many years

You can visit my blog

StackOverFlow - http://stackoverflow.com/users/314488/pranay
My CV :- http://careers.stackoverflow.com/pranayamr

Awards:

Number of different ways to get total number of rows from tables

License

Microsoft C# MVP (12-13)

You can visit my blog

Comments and Discussions