An Alternative Way To Get the Table's Rowcount

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Alexander Chigrik » An Alternative Way To Get the Table's...

An Alternative Way To Get the Table's Rowcount

Rate Topic

Display Mode

Topic Options

Author

Message

achigrik

Posted Sunday, September 23, 2001 12:00 AM

Grasshopper

Group: General Forum Members
Last Login: Saturday, September 21, 2002 12:00 AM
Points: 20, Visits: 1

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/achigrik/rowcount.asp

Post #1088

cadebryant

Posted Monday, October 01, 2001 12:57 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, November 05, 2008 2:49 PM
Points: 57, Visits: 14

This is a great article, and in most cases this is a quick and effective way to determine the number of rows. However, there is one drawback. The rowcount that is returned may not always be up-to-the-minute accurate, especially if a user has recently bulk-loaded some data into the table.

Post #21741

gds_78

Posted Tuesday, October 16, 2001 1:09 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, December 01, 2003 12:00 AM
Points: 1, Visits: 1

For example, I have a sales detailed table, containing barcodes and its quantity that are sold for the day. What If I want to query the number of items of each barcode that was sold out for the day, so my query would look like this:

SELECT outlet, sales_date, barcode, count(qty) as Quanity
FROM sales

Can i still use your example?

Post #21742

Henry C Martin

Posted Friday, October 27, 2006 7:27 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, January 09, 2007 5:32 AM
Points: 5, Visits: 1

This was an informative articule to find row counts. I appreciate the ease and convienance of this article.

Post #318697

« Prev Topic | Next Topic »

Permissions