注册 登录
编程论坛 SQL Server论坛

好人们帮我翻译下这些代码...我要做毕业设计啊

发布于 2008-06-07 02:51, 971 次点击
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
1 回复
#2
2008-06-09 09:32
简单解释一下哦
/*这是一个往表ShopCart中插数据的存储过程*/
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
1