Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
CREATE PROCEDURE UpdateInventory (@OrderID int, @CartID char (36)) AS DECLARE @Quantity INT SELECT @Quantity = ShoppingCart.Quantity FROM ShoppingCart INNER JOIN Product ON ShoppingCart.ProductID = Product.ProductID WHERE ShoppingCart.CartID = @CartID UPDATE Product SET Inventory = (Inventory - @Quantity) WHERE ShoppingCart.ProductID = Product.ProductID
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!