1,带输出参数
创建存储过程:
- 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
接收输出参数:
- DECLARE @count INT
- EXECUTE GetCustomers @count OUTPUT
- PRINT @count
2,带返回值
创建存储过程:
- 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 @count=GetCustomers
- PRINT @count
source:http://blog.csdn.net/program035/archive/2011/04/29/6371481.aspx