关于事务

[gutlgutl]

creat proc name
as

insert table1 select tb from ..
insert table2 select tb from...
.....
.....
我想加个事务，如果这个过程中出现错误，我想让之前插入的数据全部回滚，应该怎么写，是直接在这里写，还是建个触发器比较好?

[zlp321002]

creat proc name
as
set xact_abort on
begin
begin tran
insert table1 select tb from ..
insert table2 select tb from...
.....
.....
commit tran
end

[sky266]

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