"usp_ShoppingCartUpdate" Stored Procedure

Description:

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.