get rowcount from select SP before returning all records?

  • Thread starter Thread starter John B
  • Start date Start date
J

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
 
It is not the executing that I am bothered about. It is passing the data
across the network to the client.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

@@ROWCOUNT 2
Output Parameter Returns Nothing 1
@@rowcount changed before Stored Proc. can check it 6
Retrieving actual rowcount from SQLDataAdapter when using StartRec 1
get record count from stored procedure without passing DATA back? 2
SQLDataReader and Stored Procedure Problem 1
TableAdapter returns null for stored proc returning a single value 3
DataSet and SQL results dont match, help 2

Back
Top