Using SQL Server

Create an INSTEAD OF trigger named Products_UPDATE that error checks the updated value of DiscountPercent column of the Products table. If the discount percent is less than 0 or greater than 100, the trigger should throw an error. If the discount percent is greater than 0 but less than or equal to 1, this trigger should update the new discount percent by multiplying it by 100. That way, a discount percent of .2 becomes 20. If the discount percent is greater than 1 but less than 100, the trigger should update the new discount percent normally.

Test this trigger with the following updates

UPDATE Products SET DiscountPercent = -10.0 WHERE ProductID = 1;

UPDATE Products SET DiscountPercent = 120.0 WHERE ProductID = 1;

UPDATE Products SET DiscountPercent = .25 WHERE ProductID = 1;

UPDATE Products SET DiscountPercent = 50 WHERE ProductID = 1;