SQL Server/T-SQL Tutorial/System Settings/ROWCOUNT BIG

Материал из SQL эксперт
Перейти к: навигация, поиск

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)