create trigger t1
on A
for delete
as
delete from AENTRY
where INTERID in(select INTERID from deleted)
or charindex(1933,interid)>0 or charindex(2601,interid)>0
然后:
delete from A
where exists(select * from A where charindex(4947 ,interid)>0 or charindex(5777 ,interid)>0)