Stored Procedures: Output Parameters

Stored procedures, unlike functions, do not have to return any data back to the caller. They only execute the code that they encompass. Nevertheless, it is possible to return a result back from stored procedures. We can mark a parameter of a stored procedure with the OUTPUT keyword so that the value of the parameter can be used in the context where the stored procedure is called. In other words, using output parameters is one of the ways of returning data from stored procedures.

Syntax

Output parameters are declared in the ...