Question: First part done but not understanding that It asked to modify the trigger created in step 1 to execute its check code only if the

First part done but not understanding that It asked to modify the trigger created in step 1 to execute its check code only if the Quantity column is updated. This is the code used for first part: Use AdventureWorks2016CTP3 CREATE TRIGGER tgrExcessInventory on Production.ProductInventory AFTER INSERT,UPDATE AS IF EXISTS (SELECT 'True' FROM Inserted i JOIN Deleted d ON i.productID = d.ProductID AND i.locationID = d.LocationID WHERE (d.quantity + i.quantity) >= 1000 OR i.quantity >=1000 ) BEGIN RAISERROR('Cannot increase stock where units would be over 1,000 units',16,1) ROLLBACK; END; GO

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!