1. @@ROWCOUNT returns the number of rows affected by the last statement.
2. If the number of rows is more than 2 billion, use ROWCOUNT_BIG.
3. Return type of @@ROWCOUNT is int.
4. You can set this @@rowcount to some other variable and use them for further processing.
Examples
______________________________
1. SELECT * FROM employee
PRINT @@rowcount
Output
______________________________
5 —-as there are 5 rows in the table
2.SELECT * FROM employee
PRINT ‘sdfsd’
PRINT @@rowcount
Output
______________________________
0 —-as the last executed statement does not affect any rows.
3.
DECLARE @rows AS INT
SELECT * FROM employee
SET @rows = @@rowcount
PRINT ‘No of Rows’ + SPACE(1) + ‘:’ + SPACE(1) + CAST(@rows AS VARCHAR(2))
Output
______________________________
No of Rows : 5 —-as there are 5 rows in the table
Happy Programming.
Pawan Kumar
pawankkmr@gmail.com