ALTER Procedure GoodsDetail
(
@GoodsID int,
@ModelNumber nvarchar(50) OUTPUT,
@ModelName nvarchar(50) OUTPUT,
@GoodsImage nvarchar(50) OUTPUT,
@UnitCost money OUTPUT,
@GoodsDescription nvarchar(4000) OUTPUT
)
AS
SELECT
@GoodsID = GoodsID,
@ModelNumber = ModelNumber,
@ModelName = ModelName,
@GoodsImage = GoodsImage,
@UnitCost = SalePrice,
@GoodsDescription = GoodsDescription
FROM
Goods
WHERE
GoodsID = @GoodsID