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.