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>