sql server 事务处理例子

最新推荐文章于 2024-09-09 21:50:30 发布

原创最新推荐文章于 2024-09-09 21:50:30 发布 · 1.5k 阅读

2 ·

CC 4.0 BY-SA版权

本文介绍了一个使用SQL进行事务处理及批量插入操作的例子，包括更新简历状态、获取姓名及进行复杂的数据插入过程。通过错误计数确保了事务的完整性和数据一致性。

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