如何在一个存储过程调用另一个带有输入参数的存储过程
要调用 下面proc ,并且 多了一句 SELECT ProductName, UnitPrice
FROM Products
WHERE ProductID = @MyProductID ,必须也得 声明这么多参数 ?
===========================
ALTER PROCEDURE AddProduct2
@MyProductName nvarchar(40),
@MySupplierID int,
@MyCategoryID int,
@MyQuantityPerUnit nvarchar(20),
@MyUnitPrice money,
@MyUnitsInStock smallint,
@MyUnitsOnOrder smallint,
@MyReorderLevel smallint,
@MyDiscontinued bit
AS
DECLARE @MyProductID int
-- insert a row into the Products table
INSERT INTO Products (
ProductName, SupplierID, CategoryID, QuantityPerUnit,
UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel,
Discontinued
) VALUES (
@MyProductName, @MySupplierID, @MyCategoryID, @MyQuantityPerUnit,
@MyUnitPrice, @MyUnitsInStock, @MyUnitsOnOrder, @MyReorderLevel,
@MyDiscontinued
)
SET @MyProductID = SCOPE_IDENTITY()
RETURN @MyProductID