Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to call the stored procedure in the Sql Server stored procedure to receive the return value of the output parameters. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

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

Receive output parameters:

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

2, with return value

Create a stored procedure:

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

Receive the return value:

DECLARE @ count INT EXECUTE @ count=GetCustomers PRINT @ count on how to call a stored procedure in a Sql Server stored procedure to receive the returned values of output parameters is shared here. I hope the above can be helpful to you and learn more. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.