关于 触发器 删除
树莓派 2006-11-24 04:17:54 主表和副表 一对多的关系。
现在的问题,主表删除一条,附表的所以纪录都删除了
代码如下
Create TRIGGER UDT_CM070_GINKO ON dbo.CM070_GINKO FOR UPDATE AS
SET NOCOUNT ON
IF UPDATE(GinkoCd)
BEGIN
UPDATE CM071_GINKO
SET CM071_GINKO.GinkoCd = inserted.GinkoCd ,
CM071_GINKO.ZenginkyoCd = inserted.GinkoCd + CM071_GINKO.ShitenCd
FROM CM071_GINKO, deleted, inserted
WHERE deleted.GinkoCd = CM071_GINKO.GinkoCd
AND deleted.KaishaCd = CM071_GINKO.KaishaCd
AND deleted.KanriCd = CM071_GINKO.KanriCd
END
GO
Create TRIGGER DEL_CM070_GINKO ON dbo.CM070_GINKO FOR DELETE
AS
SET NOCOUNT ON
BEGIN
DELETE CM071_GINKO FROM CM071_GINKO ,deleted
WHERE CM071_GINKO.GinkoCd = deleted.GinkoCd
AND CM071_GINKO.KaishaCd = deleted.KaishaCd
AND CM071_GINKO.KanriCd = deleted.KanriCd
END
GO
主表示070,附表是071 ,GinkoCd KaishaCd KanriCd 是主键