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

This article is about how sql gets the data returned by stored procedures. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

That is, after the storage is executed, the data executed by the stored procedure is obtained and used as other secondary uses.

In fact, it can be said to be similar to calling in the code, and the specific operations are as follows:

Create a stored procedure:

Use [library name] goset ansi_null onGOSET QUOTED_IDENTIFIER ONGOCREATE PROCEDURE DBO.P_TEST (@ RBACK VARCHAR (20) OUT-where out represents the one to be returned) ASBEGIN TRY SET @ RBACK= (SELECT 2) END TRY

The above script just returns a result that 2-2 equals 4

In external how to call, or in other stored procedure scripts, as follows:

Declare @ RBACK VARCHAR (20) EXEC Library name .dbo.P _ TEST @ REBACK OUTSELECT @ REBACK

Execution returns 4, so you can use it more flexibly, calling the

It is much more convenient in the later work.

Thank you for reading! This is the end of the article on "how to get the data returned by stored procedures in sql". I hope the above content can be of some help to you, so that you can learn more knowledge. 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.