deletetrigger.sql

简单的SQL Server数据库安装

CREATE TRIGGER "tSaleOrderMst_DTrig" ON tSaleOrderMst FOR DELETE AS
SET NOCOUNT ON
/* * PREVENT DELETES IF DEPENDENT RECORDS IN 'tReceiveDtl' */
IF (SELECT COUNT(*) FROM deleted, tReceiveDtl WHERE (deleted.ID = tReceiveDtl.SaleOutID)) > 0
    BEGIN
        RAISERROR 44445 '无法删除或更改该记录。因为表“tReceiveDtl”中存在有相关记录，删除或更改时将违反参照完整性规则。'
        ROLLBACK TRANSACTION
    END

/* * CASCADE DELETES TO 'tSaleOrderDtl' */
DELETE tSaleOrderDtl FROM deleted, tSaleOrderDtl WHERE deleted.ID = tSaleOrderDtl.ID

DELETE tSaleOrderDtl1 FROM deleted, tSaleOrderDtl1 WHERE deleted.ID = tSaleOrderDtl1.ID