CREATE TRIGGER tri_fdate_del
ON zg_f_date
FOR DELETE
AS
DELETE a
FROM zg_xp_jilu a join zg_f_date b on b.f_id=a.fd_id
GO
ON zg_f_date
FOR DELETE
AS
DELETE a
FROM zg_xp_jilu a join zg_f_date b on b.f_id=a.fd_id
GO
DELETE FROM zg_xp_jilu
from zg_xp_jilu a join zg_f_date b on b..f_id=a.fd_id
ON zg_f_date
FOR DELETE
AS
DELETE a
FROM zg_xp_jilu a where exists(select 1 from zg_f_date where b.f_id=a.fd_id)
GO
DELETE FROM zg_xp_jilu
from zg_xp_jilu a join zg_f_date b on b.f_id=a.fd_id
ON zg_f_date
FOR DELETE
AS
DELETE a
FROM zg_xp_jilu a join deleted b on b.f_id=a.fd_id
GO
就算没有危害,效率也是低的