Post reply

An Alternative Way To Get the Table's Rowcount

  • September 23, 2001 at 12:00 am

    #157578

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

  • October 1, 2001 at 12:57 pm

    #418591

    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.

  • October 16, 2001 at 1:09 am

    #419029

    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?

  • October 27, 2006 at 7:27 am

    #668489

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply