creat proc name
as insert table1 select tb from ..
insert table2 select tb from...
.....
.....
我想加个事务,如果这个过程中出现错误,我想让之前插入的数据全部回滚,应该怎么写,是直接在这里写,还是建个触发器比较好?
as insert table1 select tb from ..
insert table2 select tb from...
.....
.....
我想加个事务,如果这个过程中出现错误,我想让之前插入的数据全部回滚,应该怎么写,是直接在这里写,还是建个触发器比较好?
as
set xact_abort on
begin
begin tran
insert table1 select tb from ..
insert table2 select tb from...
.....
.....
commit tran
end
as
begin tran
insert table1 select tb from ..
insert table2 select tb from...
if @@error>0
begin
rollback tran
end
else
begin
commit tran
end