【SQL开源代码栏目提醒】:网学会员为需要SQL开源代码的朋友们搜集整理了DeliveryMaster_Delete.sql相关资料,希望对各位网友有所帮助!
CREATE TRIGGER DeliveryMaster_Delete
ON DeliveryMaster
FOR Delete
AS
IF @@ROWCOUNT = 0 RETURN
DECLARE @CustomerID Char(10)
DECLARE @AccountReceivable Decimal(12, 0)
DECLARE @DeliveryID Char(10)
SELECT @CustomerID = CustomerID, @AccountReceivable = AccountReceivable, @DeliveryID = DeliveryID
FROM deleted
IF EXISTS(SELECT SourceID FROM VoucMaster
WHERE SourceID = @DeliveryID)
BEGIN
RAISERROR('要删除支票文件,应先删除它的明细数据。', 16, 1)
ROLLBACK
RETURN
END
UPDATE Customer SET CreditBalance = CreditBalance + @AccountReceivable
WHERE CustomerID = @CustomerID