create trigger tr_a_delete
on a
for delete
asdelete b
from deleted
where b.aid=deleted.iddelete c
from deleted
where c.aid=deleted.id...delete N
from deleted
where N.aid=deleted.idgo
on a
for delete
asdelete b
from deleted
where b.aid=deleted.iddelete c
from deleted
where c.aid=deleted.id...delete N
from deleted
where N.aid=deleted.idgo
for delete
as
delete 另一个有关联的表 where 编号 in (select 编号 from deleted)