Quick Answer: Does Stored Procedure Return Value?

Can SQL stored procedure return value?

Return Value in Stored Procedure.

Return values can be used within stored procedures to provide the stored procedure execution status to the calling program.

You can create your own parameters that can be passed back to the calling program.

By default, the successful execution of a stored procedure will return 0..

Can a procedure return a value?

A stored procedure does not have a return value but can optionally take input, output, or input-output parameters. A stored procedure can return output through any output or input-output parameter.

How many values can be returned from a stored procedure?

A Stored Procedure can have any number of output parameters. The simple logic is this — If you want to return 1 value then use 1 output parameter, for returning 5 values use 5 output parameters, for 10 use 10, and so on. In this Tutorial I will explain how to return 3 values from a Stored Procedure in C# language.

Can a stored procedure return a table?

Every stored procedure can return an integer value known as the execution status value or return code. If you still want a table returned from the SP, you’ll either have to work the record set returned from a SELECT within the SP or tie into an OUTPUT variable that passes an XML datatype.