BEGIN TRAN T1
BEGIN TRAN M2
insert jobs (job_desc,min_lvl,max_lvl) values('ghghghgh',45,56)
COMMIT TRAN M2
insert jobs (job_desc,min_lvl,max_lvl) values('shun xiao ping',45,56)
if @@ERROR<>0
ROLLBACK TRAN T1
COMMIT TRAN T1