Should Output parameter be returned from Stored Procedure?

 Posted by vishalneeraj-24503 on 12/14/2013 | Category: Sql Server Interview questions | Views: 673 | Points: 40
Answer:

No,It's not required.
As stored procedure may or may not return any value.
and output parameters work like reference variable as Out and Ref in Dot Net.It stores the value and is similar like return type in functions/methods.

Output parameters are defined as:-
Create Procedure sp_get_value(@result varchar(50) Output)
As
Go


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response