CREATE TRIGGER Products_Update
ON Products
FOR UPDATE
AS
INSERT INTO PriceTracking(ProductID, Time, OldPrice, NewPrice)
SELECT I.ProductID, GETDATE(), D.UnitPrice, I.UnitPrice
FROM Inserted I
INNER JOIN Deleted D
ON I.ProductID = D.ProductID
AND I.UnitPrice <> D.UnitPrice;
What is the purpose of this trigger?

Question

CREATE TRIGGER Products_Update ON Products FOR UPDATE AS INSERT INTO PriceTracking(ProductID, Time, OldPrice, NewPrice) SELECT I.ProductID, GETDATE(), D.UnitPrice, I.UnitPrice FROM Inserted I INNER JOIN Deleted D ON I.ProductID = D.ProductID AND I.UnitPrice <> D.UnitPrice; 
 What is the purpose of this trigger?

Answer

c.  It logs price changes into a separate table.

Answer

a.  It blocks all price updates.

Answer

b.  It prevents duplicate product IDs.

Answer

d.  It automatically adjusts product stock levels.

Crowdly

CREATE TRIGGER Products_Update ON Products FOR UPDATE AS INSERT INTO PriceTracki...

Want instant access to all verified answers on moodle.usth.edu.vn?