js_rpt_触发器.sql

本系统是一个报表分析查询系统

CREATE TRIGGER RptDel
ON dbo.Js_Rpt
FOR DELETE
AS 
 declare @FInterID int
BEGIN
 select @FInterID=Js_RptID from DELETED
 delete from Js_Title where Js_RptID=@FInterID
 delete from Js_HeaderFooter where Js_RptID=@FInterID
 delete from Js_Filt where Js_RptID=@FInterID
 delete from Js_FieldControl where Js_RptID=@FInterID
END