Output type Stored Procedure

Question

Hi What is output type stored procedure? Why we used it?

Prabhu Raja · Answer

Hi It makes stored procedure to return several values and each must be defined as an output variable in the stored procedure and in the calling statements. Example : CREATE PROCEDURE Procedurename @ReturnVariable INT OUTPUT AS //Queries Return DECLARE @myvariable int Exec Procedurename @ ReturnVariable = @myvariable out

Suthish Nair · Answer

When you want to return more than one value/record then use output type parameter.