try
BEGIN TRAN
Ins_A
Del_B
Ins_c
if(@@ERROR>0)
  ROLLBACK
ELSE
  COMMIT