This stored procedure performs an update on the given CartID with the given ProductID and Quantity. Used on the Shopping Cart screen when the user changes the quantity of an item.
Definition:CREATE Procedure usp_ShoppingCartUpdate ( @CartID nvarchar(50), @ProductID int, @Quantity int ) AS UPDATE Sales.ShoppingCartItem SET Quantity = @Quantity WHERE ShoppingCartID = @CartID AND ProductID = @ProductID;Database Tables Used:
ShoppingCartItem: The ShoppingCartItem table keeps track of the items a user has purchased. Its primary key is the ShoppingCartItemID field. The ShoppingCartID is a string which is used to identify the user who owns the basket of items. There is a many to one relationship between the ShoppingCartItem table and the Product table. Note that if not Quantity is supplied, a default of 1 is entered.