get rowcount from select SP before returning all records?

[John B]

Is is possible to obtain the number of records that would be returned by a
select sp without actually returning the records.
I have been looking at executescalar but this returns -1 for selects.

Thanks

John

 

[Sahil Malik]

Not possible without actually executing the sproc - or an alternate count
query.
It's like knowing what is inside the giftwrapping, without opening it.

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik

 

[John B]

It is not the executing that I am bothered about. It is passing the data
across the network to the client.

 

[Sahil Malik]

Executing a count(*) won't pass back much data (just a scalar).

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik