Mega Code Archive

 

Categories / MSSQL Tutorial / System Settings

 

Retrieving the Rows Affected by the Previous Statement

4> --@@ROWCOUNT returns the integer value of the number of rows affected by the last Transact-SQL statement  in the current scope. 5> --@@ROWCOUNT_BIG returns the bigint value. 6> 7> SELECT @@ROWCOUNT Int_RowCount, ROWCOUNT_BIG() BigInt_RowCount 8> GO Int_RowCount BigInt_RowCount ------------ --------------------            1                    1 (1 rows affected)