Get SQL count into variable

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Luke Davis - 25 Aug 2007 04:08 GMT

What is the quickest way to get the count of rows in a table into an int
variable?

for example how would I make this happen?

int remaining = SELECT Count(*) FROM states.dbo.cities

Reply to this Message

Smithers - 25 Aug 2007 04:55 GMT

ADO.NET's .ExecuteScalar() method is designed for returning a single value.

-HTH

> What is the quickest way to get the count of rows in a table into an int
> variable?
>
> for example how would I make this happen?
>
> int remaining = SELECT Count(*) FROM states.dbo.cities

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...