begin tran
delete from student where c_id=1
if @@error>0
ROLLBACK TRANSACTION
delete from class where c_id= 1
if @@error>0
ROLLBACK TRANSACTION
commit tran
delete from student where c_id=1
if @@error>0
ROLLBACK TRANSACTION
delete from class where c_id= 1
if @@error>0
ROLLBACK TRANSACTION
commit tran