BEGIN TRAN
insert into DB_B.dbo.Table1 select * from DB_A.dbo.Table1 where age>30
delete from DB_A.dbo.Table1 where age>30
COMMIT TRAN
如何做到DB_B中插入失败,则DB_A中不删除?
上面代码好像事务不起作用
...全文
5223打赏收藏
跨数据库的事务如何处理?
类似下面语句: BEGIN TRAN insert into DB_B.dbo.Table1 select * from DB_A.dbo.Table1 where age>30 delete from DB_A.dbo.Table1 where age>30 COMMIT TRAN 如何做到DB_B中插入失败,则DB_A中不删除? 上面代码好像事务不起作用