This article explains about @@ROWCOUNT function in sql server with examples.
@@ROWCOUNT function 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, use ROWCOUNT_BIG().
Syntax of @@ROWCOUNT Function :
Return type of @@ROWCOUNT function is an integer.
Examples of @@ROWCOUNT Function :
Example 1 : Use of @@ROWCOUNT function in select clause
SELECT ProductName, UnitPrice