An Alternative Way To Get the Table's Rowcount

  • achigrik

    SSCommitted

    Points: 1812

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

  • cadebryant

    Ten Centuries

    Points: 1035

    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.

  • gds_78

    Grasshopper

    Points: 13

    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?

  • Henry C Martin

    Grasshopper

    Points: 19

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

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

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