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.
16 lines
366 B
16 lines
366 B
|
|
drop proc ShoppingCartSum_Select
|
|
|
|
create proc ShoppingCartSum_Select
|
|
|
|
@UserEmail nvarchar(50)
|
|
|
|
as
|
|
|
|
declare @UserID int
|
|
|
|
select @UserID=CusID from dbo.Customer where CusEmail=@UserEmail
|
|
|
|
select sum( ShoppingCart.ProductNum* Product.ProdDiscount) as price from dbo.ShoppingCart,dbo.Product where ShoppingCart.UserID=@UserID and ShoppingCart.ProductID=Product.ProdID
|
|
|