创建存储过程时出现的错误

[maplelovers]

create procedure AddOrder
(
@UserID int,
@CartIDString nvarchar(50),
@OrderDate datetime,
@OrderID int output
)
as
begin tran OrderAdd
insert into Orders
(UserID,OrderDate)
values
(
@UserID,
@OrderDate
)
select @OrderID=@@Identity

insert into OrderContent(OrderID,PID,PAmount,UnitCost)
select
@OrderID
ShopCart.PID,
OrderContent.PAmount,
Product.PPrice
from
ShopCart inner join Product on ShopCart.PID=Product.PID
where
CartIDString=@CartIDString

exec EmptyShoppingCart @CartIDString
commit tran OrderAdd

列前缀 'OrderContent' 与查询中所用的表名或别名不匹配。
是怎么回事啊？帮帮忙

[永生天地]

select
@OrderID,ShopCart.PID,

[htl258_Tony]

create procedure AddOrder
(
@UserID int,
@CartIDString nvarchar(50),
@OrderDate datetime,
@OrderID int output
)
as
begin tran OrderAdd
insert into Orders
(UserID,OrderDate)
values
(
@UserID,
@OrderDate
)
select @OrderID=@@Identity

insert into OrderContent(OrderID,PID,PAmount,UnitCost)
select
@OrderID,
ShopCart.PID,
OrderContent.PAmount,
Product.PPrice
from
ShopCart inner join Product on ShopCart.PID=Product.PID
where
CartIDString=@CartIDString
exec EmptyShoppingCart @CartIDString

commit tran OrderAdd

[htl258_Tony]

[Quote=引用 1 楼 xys_777 的回复:]
select
@OrderID,ShopCart.PID,
[/Quote]，差几秒。

[永生天地]

alter procedure AddOrder
(
@UserID int,
@CartIDString nvarchar(50),
@OrderDate datetime,
@OrderID int output
)
as
begin tran OrderAdd
insert into Orders
(UserID,OrderDate)
values
(
@UserID,
@OrderDate
)
select @OrderID=@@Identity

insert into OrderContent(OrderID,PID,PAmount,UnitCost)
select
@OrderID,
ShopCart.PID,
OrderContent.PAmount,
Product.PPrice
from
ShopCart inner join Product on ShopCart.PID=Product.PID
where
CartIDString=@CartIDString

exec EmptyShoppingCart @CartIDString
commit tran OrderAdd

[feixianxxx]

create procedure AddOrder
(
@UserID int,
@CartIDString nvarchar(50),
@OrderDate datetime,
@OrderID int output
)
as
begin tran OrderAdd
insert into Orders
(UserID,OrderDate)
values
(
@UserID,
@OrderDate
)
select @OrderID=@@Identity

insert into OrderContent(OrderID,PID,PAmount,UnitCost)
select
@OrderID,
ShopCart.PID,
OrderContent.PAmount,
Product.PPrice
from
ShopCart inner join Product on ShopCart.PID=Product.PID
join OrderContent on ShopCart.PID=OrderContent.PID
where
CartIDString=@CartIDString

exec EmptyShoppingCart @CartIDString
commit tran OrderAdd

[永生天地]

[Quote=引用 3 楼 htl258 的回复:]
引用 1 楼 xys_777 的回复:
select
@OrderID,ShopCart.PID,
，差几秒。
[/Quote]
其实我也是无意的

[htl258_Tony]

[Quote=引用 5 楼 feixianxxx 的回复:]
create procedure AddOrder
(
@UserID int,
@CartIDString nvarchar(50),
@OrderDate datetime,
@OrderID int output
)
as
begin tran OrderAdd
insert into Orders
(UserID,OrderDate)
values
(
@User……
[/Quote]回快是，是还少掉一个连接对象

[-狙击手-]

insert into OrderContent(OrderID,PID,PAmount,UnitCost)
select
@OrderID
ShopCart.PID,
OrderContent.PAmount,
Product.PPrice
from
ShopCart inner join Product on ShopCart.PID=Product.PID
where
CartIDString=@CartIDString

这儿不对呀，你想要什么呀

[东那个升]

select
@OrderID
,ShopCart.PID
,OrderContent.PAmount
,Product.PPrice
from

逗号放前面一眼就看出来了，，，习惯很重要

[maplelovers]

有劳各位费心了，问题解决了。仅代表个人向回帖的各位兄弟姐妹们表示真诚的感谢。