Retrieving the Rows Affected by the Previous Statement : ROWCOUNT_BIG « System Settings « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Settings
3. ROWCOUNT_BIG

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)