SQL Server/T-SQL Tutorial/System Settings/ROWCOUNT BIG
Retrieving the Rows Affected by the Previous Statement
<source lang="sql">
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)</source>