关于 触发器 删除

[树莓派]

主表和副表 一对多的关系。
现在的问题，主表删除一条，附表的所以纪录都删除了
代码如下
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 是主键

[caixia615]

楼主有什么问题?

• 打赏
• 举报

回复 赞

[树莓派]

不知道为什么，070一条记录删除后，真个071都删除光了

• 打赏
• 举报

回复 赞

[oooooo126]

create tigger aaa on 表名1
as
delete 表名2 from deleted where 表名2.id=deleted.id

• 打赏
• 举报

回复 赞

[xiaoku]

DELETE CM071_GINKO FROM deleted --CM071_GINKO 不要?

• 打赏
• 举报

回复 赞

[树莓派]

是不是和其他的触发器邦定了，刚才作试验的时候，好像做过一个全部删除的
怎么看这个表的邦定的触发器阿，老大们

• 打赏
• 举报

回复 赞

[树莓派]

问题解决了，果然以前还有个触发器，怎么看一个表到底和多少个触发器邦定阿

• 打赏
• 举报

回复 赞