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.