SQL触发器:跟踪产品价格更新
CREATE TRIGGER trg_UpdateProduct ON dbo.Products AFTER UPDATE AS BEGIN IF UPDATE(Price) BEGIN -- 记录更新前的价格和更新后的价格 DECLARE @OldPrice DECIMAL(10,2), @NewPrice DECIMAL(10,2) SELECT @OldPrice = Price FROM deleted SELECT @NewPrice = Price FROM inserted -- 插入一条日志记录 INSERT INTO dbo.ProductLogs (ProductId, OldPrice, NewPrice, UpdateDate) SELECT id, @OldPrice, @NewPrice, GETDATE() FROM inserted END END
原文地址: https://www.cveoy.top/t/topic/pSug 著作权归作者所有。请勿转载和采集!