creat proc name
as
insert table1 select tb from ..
insert table2 select tb from...
.....
.....
我想加个事务，如果这个过程中出现错误，我想让之前插入的数据全部回滚，应该怎么写，是直接在这里写，还是建个触发器比较好?
------解决方案--------------------
creat proc name
as
set xact_abort on
begin
begin tran
insert table1 select tb from ..
insert table2 select tb from...
.....
.....
commit tran
end
------解决方案--------------------
creat proc name
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