--创建
create trigger t1_t2
on tb1
for delete
as
if @@rowcount=0 return
select * from deleted
delete from tb2 where Pid in (select ID from deleted)
--删除
DROP TRIGGER t1_t2
delete from tb1
--创建
create trigger t1_t2
on tb1
for delete
as
if @@rowcount=0 return
select * from deleted
delete from tb2 where Pid in (select ID from deleted)
--删除
DROP TRIGGER t1_t2
delete from tb1