紧急求助（这样的触发器怎么写）

Question

create trigger td_tab1 on tab1
for delete
as
   delete tab2 where id in (select id from deleted) or pid in (select id from deleted)

Answer 1

create trigger t_delete on tab1
for delete
as
delete tab2 from tab2 a join deleted b on a.id=b.id
go

Answer 2

create trigger td_tab1 on tab1
for delete
as
   delete a  from tab2 a ,deleted b where a.id = b.id or a.pid = b.id

Answer 3

create trigger t_delete on tab1
for delete
as
delete tab2  a
where exists(select * from  deleted where  a.id=id)
go