What is the best way to count the number of records in a MS SQL DB.
The way I do it is executeReader() and loop through all the records in
a db and increment variable RowCount++.

Is there already a function pre-defined for it ?

weird0 wrote:
> What is the best way to count the number of records in a MS SQL DB.
> The way I do it is executeReader() and loop through all the records in
> a db and increment variable RowCount++.
>
> Is there already a function pre-defined for it ?
>

There sure is. Use the count() aggregate in a query:

"select count(*) from SomeTable"

This will return one row that contains the number of records in the table.

--
Göran Andersson
_____
http://www.guffa.com

Weird,

You can use instead of the executeReader the almost special command for this

Command.ExecuteScalar

http://msdn.microsoft.com/library/de...calartopic.asp

On this page you see direct the sample with the count to fulfil what you
need.

(You can do of course much more with the command)

Cor


"weird0" <(E-Mail Removed)> schreef in bericht
news:(E-Mail Removed)...
> What is the best way to count the number of records in a MS SQL DB.
> The way I do it is executeReader() and loop through all the records in
> a db and increment variable RowCount++.
>
> Is there already a function pre-defined for it ?
>