谁看看这个 存储过程 where附近有错误
CREATE PROCEDURE [displayshoppingcart]
(
@cartid nvarchar
)
AS
select
goods.goodsid,
goods.modelname,
goods.modelnumber,
shoppingcarts.goodsquentity,
goods.saleprice
FROM
goods,
shoppingcarts,
WHERE
goods.goodsid=shoppingcarts.goodsid
AND
shoppingcarts.shoppingcartid=@cartid
order by
goods.modelname
goods.modelnumber
GO
[解决办法]
CREATE PROCEDURE [displayshoppingcart]
(
@cartid nvarchar
)
AS
select
goods.goodsid,
goods.modelname,
goods.modelnumber,
shoppingcarts.goodsquentity,
goods.saleprice
FROM
goods,
shoppingcarts
WHERE
goods.goodsid=shoppingcarts.goodsid
AND
shoppingcarts.shoppingcartid=@cartid
order by
goods.modelname,
goods.modelnumber
GO
这样就OK了
[解决办法]
太不小心了就是太粗心了也就是太心胸广阔了^o^
[解决办法]
where前面多一个逗号
