xybrek xybrek - 1 year ago 71
SQL Question

Counting the number of rows returned by stored procedure

How do I count the number of rows a stored procedure would return the fastest way. Stored procedure returns rows around 100K to 1M records.

Answer Source

Select @@rowcount:


After executing the stored procedure.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download