"usp_ShoppingCartRemoveItem" Stored Procedure

Description:

This stored procedure deletes the given ProductID from the given CartID.  It is used on the Shopping Cart screen when an item is removed from the shopping cart.

Definition:
CREATE Procedure usp_ShoppingCartRemoveItem
(
    @CartID nvarchar(50),
    @ProductID int
)
AS

DELETE FROM Sales.ShoppingCartItem
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.