34,590
社区成员
发帖
与我相关
我的任务
分享
create trigger trig_delete_a on a
for delete
as
delete b from deleted where b.colname=deleted.外键
go
--如果不用触发器的话,用外键的级联删除功能,更简单。
create trigger A_trigger on A delete
as
begin
delete from B where B.字段 in(select A.字段 from deleted)
end