sql server 事务处理例子

begin tran one_tran

declare @sum_errors int;   //声明error总数，这个用来判断事务是否回滚

set @sum_errors = 0;

update tbl_recruit_resume set entry_status = 0 where id = 26;

set @sum_errors = @sum_errors + @@error;

declare @name varchar(10);
select @name = name from tbl_recruit_resume where id = 26;


insert into tbl_xz_rsgl(name,ruzhishijian,sex,worker_no,alias_name,department,report_object,zhiwu,mobile,telephone,email,idcard,birthday,work_type,probation_period,school,zhuanye,marry,jiguan,nation,zhengzhimianmao,zhicheng,hetongqishiriqi,hetongzhogzhiriqi,baomiqiandingriqi,jibengongzi,gongzijisuanfangfa,area,worker_status,add_usr_id,edit_usr_id,guid_out,guid_in,deleted,set_time,add_time,is_locked) 

(select a.name,'2016-04-08',1,'','',b.work_department,b.report_object,b.work_position,a.mobile,'',a.email,'440456200102035566','2001-04-08',0,'0','','',1,34,0,0,0,'','','',0,0,'',1,0,0,NULL,NULL,0,'2016-04-08 12:12:54','2016-04-08 12:12:54',0 from tbl_recruit_resume a left join  tbl_recruit_offer b  on a.id = b.apply_name  where a.id = 26);

set @sum_errors = @sum_errors + @@error;

if @sum_errors <> 0
begin
    rollback tran one_tran
end
else
begin
   commit tran one_tran

end