counting records with SQL statement

Results 1 to 3 of 3

Thread: counting records with SQL statement

  1. #1
    Fazio82_7 Guest

    Default counting records with SQL statement

    First, I want to thank Bill for his comment on my question yesterday... :)<BR> Now, for my next question...<BR>Is there a way (using either ADO or SQL statements)to count how many records I have in a database table without making a recordset? Creating a recordset for a task like this seems to be a waste of resources. If you have any ideas, please don&#039;t be shy...thanks a mil :)<BR><BR>Fazio

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default What is tht ASP question again???

    This is a Db related question<BR><BR>well you HAVE To open the recordset but you can <BR><BR>select count(*) from tableName and retrieve only one record and not all the records to get the number or records

  3. #3
    Fazio82_7 Guest

    Default much appreciated

    Thank you, Akhilesh <BR>I appreciate your advice...<BR><BR>(sorry about the poor selection of forums)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts