Question

我试图制定习俗,删除关于父母与子女关系的规则。我想做的是,如果儿童一栏是假造的,就在儿童身上使用cade子,如果该一栏是真实的,则适用不采取行动的规则。我如何能够这样做?

Answer 1

根据你的意见,你可以在您的桌子上写出一个这样的触发点:

CREATE TRIGGER tr_ParentTable_Update
    ON ParentTable
    FOR INSERT, UPDATE
AS
BEGIN
    IF UPDATE(IsDeleted) BEGIN
        DELETE FROM ct
            FROM inserted i
                INNER JOIN ChildTable ct
                    ON i.ID = ct.ParentID
                        AND ct.IsActive = 0
            WHERE i.IsDeleted = 1
    END /* IF */
END /* Trigger */

友情链接