ROWCOUNT_BIG function returns number of rows affected by last executed statement. It works same as
@@ROWCOUNT except the return type differs.
This variable is set to 0 by any statement that does not return rows, such as an IF statement.
If the table has more than 2 billion rows, use ROWCOUNT_BIG().
Syntax of ROWCOUNT_BIG Function :
ROWCOUNT_BIG()
Return type of ROWCOUNT_BIG function is a bigint.
Examples of ROWCOUNT_BIG Function :
Example 1 : Use of ROWCOUNT_BIG function in select clause
SELECT ProductName, UnitPrice
FROM Products
SELECT ROWCOUNT_BIG()
Output
76
Above example returns total row count returned by last statement.