The @@rowcount system parameter indicates the number of rows affected by the LAST statement. Since you have no statements preceding the conditional 'IF' statement, it will always return zero.

If you are interested in the rows updated/inserted in a table, have a look at the 'inserted' and 'deleted' special tables.