js_rpt_触发器.sql

来自「本系统是一个报表分析查询系统」· SQL 代码 · 共 12 行

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