CREATE TRIGGER 名3 ON A
FOR delete
AS
delete B where exists (select 1 from deleted where Id1=b.Id1 and id2=b.id2)
FOR delete
AS
delete B where exists (select 1 from deleted where Id1=b.Id1 and id2=b.id2)
调试欢乐多
on 表A
for delete
as
delete from 表B where
exists(select 1 from deleted where Idl=表B.Id1 and Id2=表B.Ide2
FOR delete
AS
delete B from deleted aa where B.Id1=aa.Id1 and B.Id2=aa.Id2