ROWCOUNT_BIG function in SQL server ?

ROWCOUNT_BIG() function is used to return the no of rows affected by the last statement.

This function operates like @@ROWCOUNT function in SQL server.

@@ROWCOUNT  Returns INT datatype but ROWCOUNT_BIG returns BIGINT.

Syntax

ROWCOUNT_BIG ()

This function returns the no of affected by the last statement such as select, insert, update and delete statements.