select @@rowcount-- check this one out

select @@rowcount-- check this one out

select @@rowcount -- check this one out

select @@rowcount  -- check this one out

select @@rowcount  
-- check this one out

select @@rowcount- - check this one out

select rowcount -- check this one out

select @@rowcount -
- check this one out

select @@rowcount -- check
this one out

SELECT @@ROWCOUNT /* Will return 1, even though we've not previousiy run a statement */

SELECT 1 WHERE 2 = 1 /* Will an empty record set */

SELECT @@ROWCOUNT /* Will return 0 as expected as the previous statement returned no rows */

SELECT @@ROWCOUNT /* Will return 1 as the previous statement returned a row i.e of 0 */