Output parameters for SQL Server stored procedures

To do the return of the parameters on the one hand to do with the storage process of cooperation, on the one hand also have to call the method of cooperation, that is, the wrong call method is no way to return the value.

Here is an example

--1 and storage process coordination

CREATE PROCEDURE Dbo.usp_c @i as int output---* * Note that this is the OUTPUT keyword * *---

As

Begine

Set @i = 100;

End

--2, the coordination of the call

DECLARE @j as int = 1;

exec dbo.usp_c @j output;--** Note that there is also an output keyword, otherwise it will not be returned **--

The Select @j;--runs with a result of 100 indicating that @j was returned.

Output parameters for SQL Server stored procedures