You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
|
|
|
|
|
|
|
create proc ShoppingCartClear_Delete
|
|
|
|
@UserEmail nvarchar(50)
|
|
|
|
|
|
as
|
|
|
|
declare @UserID int
|
|
|
|
select @UserID=CusID from dbo.Customer where CusEmail=@UserEmail
|
|
|
|
delete dbo.ShoppingCart where UserID=@UserID
|