【SQL开源代码栏目提醒】:以下是网学会员为您推荐的SQL开源代码-PurchaseMaster_Delete.sql,希望本篇文章对您学习有所帮助。
CREATE TRIGGER PurchaseMaster_Delete
ON dbo.PurchaseMaster
FOR DELETE
AS
IF @@ROWCOUNT = 0 RETURN
DECLARE @PurchaseID Char(10)
SELECT @PurchaseID = PurchaseID
FROM deleted
IF EXISTS(SELECT SourceID FROM VoucMaster
WHERE SourceID = @PurchaseID)
BEGIN
RAISERROR('要删除支票文件,应先删除它的明细数据。', 16, 1)
ROLLBACK
RETURN
END