34,587
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE A1(X VARCHAR(10) PRIMARY KEY)
CREATE TABLE A2(Y VARCHAR(10) REFERENCES A1(X))
CREATE TABLE A4(X VARCHAR(10) )
INSERT INTO A1 VALUES(1)
begin tran
insert into AAA.dbo.a3 values(5)
insert into a2 values(2)
if @@error<>0
rollback tran
else
commit tran
set xact_abort on
begin try
begin tran
...
commit tran
end try
begin catch
rollback tran
end catch
set xact_abort on
begin catch
begin tran
...
commit tran
end catch
begin try
rollback tran
end try