@@rowcount with MSSQL

@@ROWCOUNT returns the number of rows affected or read depending on the operation.

terms as follows

• @@ROWCOUNT returns the number of rows returned to the user for a SELECT.
• @@ROWCOUNT returns the number of rows affected after issuing a INSERT, DELETE, or UPDATE.

e.g



SELECT emp_firstname,emp_lastname from emp_details ;


out put is


emp_firstname emp_lastname

yogesh k

Jhon Bush


out put returns two rows

if we execute following after this the n

SELECT @@ROWCOUNT AS 'Rows previously affected';

then out put will be

Rows previously affected
------------------------
2

(1 row(s) affected

But if we execute query like


SELECT Count(*) as rowcount from emp_details
then

out put is

rowcount
-----------
2

(1 row(s) affected)

and we execute following after this
SELECT @@ROWCOUNT AS 'Rows previously affected';


then

out put is

Rows previously affected
------------------------
1

(1 row(s) affected)

• Notice it tells you that it sent back only 1 row to the user.because only one row is return to user