34,576
社区成员
发帖
与我相关
我的任务
分享
BEGIN TRY
BEGIN TRANSACTION;
--------XXXXXXXXXXXXXXxxx
COMMIT TRANSACTION;
END TRY
BEGIN CATCH
Rollback tran
END CATCH;
set xact_abort on
begin tran
INSERT INTO t1 VALUES (1)
INSERT INTO t2 VALUES (2)
commit tran
begin tran
insert into t1(...) values(...)
if @@error <>0
begin
rollback tran
end
else
insert into t2(...) values(...)
if @@error <>0
begin
rollback tran
end
else
commit tran
end