SqlServer存储过程调用存储过程接收输出参数返回值

创建存储过程：

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  

查看更多关于SqlServer存储过程调用存储过程接收输出参数返回值的详细内容...