@@ROWCOUNT - ROWCOUNT Function in SQL?

Question

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 :

@@ROWCOUNT

Return type of @@ROWCOUNT function is an integer.

 

Examples of @@ROWCOUNT Function :

Example 1 : Use of @@ROWCOUNT function in select clause 

SELECT ProductName, UnitPrice

FROM    Products

SELECT @@ROWCOUNT

Output

76