Get # of records "affected by" statement

[alistairpaul]

Similar to the @@ERROR, is there a way to programmatically get the number of records affected by a SQL Statement issued by a program?

MS SQL Server 7.0 If my post was helpful, please Mark it below. Thanks! - Al

 

[alistairpaul]

Okay - I found it myself -

For anyone that needs to know, use:

SELECT @@ROWCOUNT

to get the number of rows affected by a statement issued against SQL Server. If my post was helpful, please Mark it below. Thanks! - Al