Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

An Alternative Way To Get the Table's Rowcount Expand / Collapse
Author
Message
Posted Sunday, September 23, 2001 12:00 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Monday, October 1, 2001 12:57 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, November 5, 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
Posted Tuesday, October 16, 2001 1:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 1, 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
Posted Friday, October 27, 2006 7:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 9, 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 »

Add to briefcase

Permissions Expand / Collapse