34,590
社区成员
发帖
与我相关
我的任务
分享
--try
CREATE Procedure spShoppingCartAddItem_s
(
@customerid varchar(10),
@ProductID INT,
@Quantity INT,
@DateTimed varchar(20)
)
As
begin tran
DECLARE @CountItems int
SELECT
@CountItems = Count(ProID)
FROM
ShoppingCart_s
WHERE
ProID = @ProductID
And
convert(varchar(10),dateTimed,120)=@DateTimed
IF @CountItems = 0 /* 只允许有一人抢购到 */
begin
INSERT INTO ShoppingCart_s
(
customerid,
Quantity,
ProID,
DateTimed
)
VALUES
(
@customerid,
@Quantity,
@ProductID,
getdate()
)
end
commit
GO