SQL SERVER預存程序調用預存程序並接收輸出參數或傳回值的方法

一個帶輸出參數的預存程序的例子：

ALTER PROCEDURE [dbo].[GetCustomers]
(@rowcount INT OUTPUT)
AS
    SELECT [CustomerID]
      ,[CompanyName]
      ,[ContactName]
      ,[ContactTitle]
      ,[Address]
      ,[City]
      ,[Region]
      ,[PostalCode]
      ,[Country]
      ,[Phone]
      ,[Fax]
  FROM [Northwind].[dbo].[Customers]
SET @rowcount=@@rowcount

 

再給一個有傳回值的預存程序       

ALTER PROCEDURE [dbo].[GetCustomers]
AS
    SELECT [CustomerID]
      ,[CompanyName]
      ,[ContactName]
      ,[ContactTitle]
      ,[Address]
      ,[City]
      ,[Region]
      ,[PostalCode]
      ,[Country]
      ,[Phone]
      ,[Fax]
  FROM [Northwind].[dbo].[Customers]
RETURN @@rowcount

那麼，如何在別的預存程序中調用該預存程序，並且接收它的輸出參數或者傳回值參數呢

下面是接收輸出參數的樣本

DECLARE @count INT
EXECUTE GetCustomers  @count OUTPUT
PRINT @count

下面是接收傳回值參數的樣本

DECLARE @count INT
EXECUTE @count=GetCustomers
PRINT @count