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