You were told to use the @@ROWCOUNT function. Here is how you would use it:

delete from bill_detail where bill_detail in (9878506)

and policy = 4236807;

SET @v_delete = @@ROWCOUNT;

update prem set written_prem = 50,

commission_amt = 7.50,

audit_id = USER,

last_modified = SYSDATE

where prem in (85272831)

and policy = 3567140;

SET @v_update = @@ROWCOUNT;

update bill_detail set gross_amt = 50,

commission_amt = 7.50,

net_amt = 42.5

where bill_detail = 9881358 and policy = 3567140;

SET @v_update = @v_update + @@ROWCOUNT;

update installment set remaining_prem = 50,

installment_status = 'Future',

-- original_prem = 501,

total_due = 50,

paid_date = NULL,

bill_date = NULL

where installment = 21820355

and policy = 3567140;

SET @v_update = @v_update + @@ROWCOUNT;

Not saying the code above will work in SQL Server as the only parts I modified were where @@ROWCOUNT is used.