Create an UPDATE trigger called tr_check_qty on the OrderDetails table to prevent the updating of orders of products that have units-in-stock less than the quantity ordered. Use the following query to...

Create an UPDATE trigger called tr_check_qty on the OrderDetails table to prevent the
updating of orders of products that have units-in-stock less than the quantity ordered. Use
the following query to test your trigger.
UPDATE OrderDetails
SET Quantity = 40
WHERE OrderID = 10044
AND ProductID = 77