就是下面这一段哪位大哥可不可以加个说明。。万分感谢
CREATE Procedure AddOrder
(
@UserID int,
@CartIDString nvarchar(50),
@OrderDate datetime,
@OrderID int OUTPUT
)
ASBEGIN TRAN OrderAdd/* Create the Order header */
INSERT INTO Orders
(
UserID,
OrderDate
)
VALUES
(
@UserID,
@OrderDate
)SELECT
@OrderID = @@Identity /* Copy items from given shopping cart to OrdersDetail table for given OrderID*/
INSERT INTO OrderContent
(
OrderID,
BookID,
BookQuantity,
UnitCost
)SELECT
@OrderID,
ShoppingCarts.BookID,
BookQuantity,
Book.SalePriceFROM
ShoppingCarts
INNER JOIN Book ON ShoppingCarts.BookID = Book.BookID
WHERE
CartIDString = @CartIDString/* Removal of items from user's shopping cart will happen on the business layer*/
EXEC EmptyShoppingCart @CartIDStringCOMMIT TRAN OrderAddGO
CREATE Procedure AddOrder
(
@UserID int,
@CartIDString nvarchar(50),
@OrderDate datetime,
@OrderID int OUTPUT
)
ASBEGIN TRAN OrderAdd/* Create the Order header */
INSERT INTO Orders
(
UserID,
OrderDate
)
VALUES
(
@UserID,
@OrderDate
)SELECT
@OrderID = @@Identity /* Copy items from given shopping cart to OrdersDetail table for given OrderID*/
INSERT INTO OrderContent
(
OrderID,
BookID,
BookQuantity,
UnitCost
)SELECT
@OrderID,
ShoppingCarts.BookID,
BookQuantity,
Book.SalePriceFROM
ShoppingCarts
INNER JOIN Book ON ShoppingCarts.BookID = Book.BookID
WHERE
CartIDString = @CartIDString/* Removal of items from user's shopping cart will happen on the business layer*/
EXEC EmptyShoppingCart @CartIDStringCOMMIT TRAN OrderAddGO
哪一句不明白的留言给我
[email protected]