|
#2
2008-06-09 09:32
简单解释一下哦
|
CREATE Procedure [dbo].[AddItemtoShoppingCart]
(
@CartIDString nvarchar(50),
@BookID int,
@BookQuantity int
)
As
DECLARE @CountItems int
SELECT
@CountItems = Count(BookID)
FROM
ShopCart
WHERE
BookID = @BookID
AND
CartIDString = @CartIDString
IF @CountItems > 0
UPDATE
ShopCart
SET
BookQuantity = (@BookQuantity + ShopCart.BookQuantity)
WHERE
BookID = @BookID
AND
CartIDString = @CartIDString
ELSE
INSERT INTO ShopCart
(
CartIDString,
BookQuantity,
BookID
)
VALUES
(
@CartIDString,
@BookQuantity,
@BookID
)
GO