returns number of rows affected by last executed statement.
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,then we can use use ROWCOUNT_BIG() function.Return type of @@ROWCOUNT function is always an integer. Syntax:-
SELECT * Output will be no of row affected.