27,579
社区成员
发帖
与我相关
我的任务
分享
-用事務
begin tran
delete b from a inner join b on a.uid=b.uid where a.id=1
delete from a where id=1
commit tran
delete b from a inner join b on a.uid=b.uid where a.id=1
delete from a where id=1
CREATE TRIGGER trigDelete
ON A
instead of delete
AS
BEGIN
delete B from A inner join B on A.UID =B.UID WHERE A.ID=(select distinct ID from deleted)
END