Usage of @ @ROWCOUNT in SQL Server

The @ @ROWCOUNT in SQL Server returns the number of rows affected by the previous statement, and the return value type is int integer. if the number of rows is greater than 2 billion, you need to use Rowcount_big.

The values of the @ @ROWCOUNT and @ @ERROR variables always change after a statement is executed, so we should first save them in local variables as a basis for judgment. They reflect the impact of the last statement immediately after them!

We can usually detect whether any rows have changed by using the UPDATE, INSERT statement, and @ @ROWCOUNT.

Here is an example of using @ @ROWCOUNT:

SQL Code Replication

Reprinted from: http://www.aspnetjia.com/Cont-109.html

Usage of @ @ROWCOUNT in SQL Server