--示例 create trigger tr_delete on 表A for deleted as delete from 表B where id in(select id from deleted) if @@error>0 --如果删除出错,回滚事务 rollback tran
可以的,例: CREATE TRIGGER TestTrig ON A FOR INSERT AS SAVE TRANSACTION MyName DELETE FROM B WHERE id IN (SELECT id FROM inserted) IF (@@error <> 0) BEGIN ROLLBACK TRANSACTION MyName END
create trigger tr_delete on 表A
for deleted
as
delete from 表B where id in(select id from deleted)
if @@error>0 --如果删除出错,回滚事务
rollback tran
CREATE TRIGGER TestTrig ON A FOR INSERT AS
SAVE TRANSACTION MyName
DELETE FROM B WHERE id IN (SELECT id FROM inserted)
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION MyName
END