建个triggercreate trigger auto_delete on a for delete delete * from b , deleted t where b.s = t.screate trigger auto_delete on b for delete delete * from a , deleted t where a.s = t.s
create trigger sp_delete_a on a for delete as delete b from b,deleted d where d.s=b.s create trigger sp_delete_a on b for delete as delete a from a,deleted d where a.s=d.s
for delete
delete * from b , deleted t where b.s = t.screate trigger auto_delete on b
for delete
delete * from a , deleted t where a.s = t.s
for delete
as
delete b from b,deleted d where d.s=b.s
create trigger sp_delete_a on b
for delete
as
delete a from a,deleted d where a.s=d.s