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