SQL Server Stored Procedures call stored procedures receive output parameter return values, SQL stored procedures
Create a stored procedure:
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
Receiving output parameters:
DECLARE @count INT EXECUTE GetCustomers @count OUTPUT PRINT @count
2, with return values
Create a stored procedure:
ALTER PROCEDURE [dbo].[GetCustomers] AS SELECT [CustomerID] ,[CompanyName] ,[ContactName] ,[ContactTitle] ,[Address] ,[City] ,[Region] ,[PostalCode] ,[Country] ,[Phone] ,[Fax] FROM [Northwind].[dbo].[Customers] RETURN @@rowcount
Receive return values:
DECLARE @count INT EXECUTE @count=GetCustomers PRINT @count
The above is a small part of the SQL Server Stored Procedure Call stored procedure to receive the output parameter return value. I hope it will help you. If you have any questions, please leave a message for me, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!