39 Output parameter in Stored Procedure | SQL Server
What is an Output Parameter?
An output parameter is used to return a value from a stored procedure back to the caller.
Complete playlist is here: • SQL Server Basics For Beginners
👉 Unlike normal SELECT, it returns a single value via a variable.
Key Points (Explain in Video)
Must use keyword OUTPUT in:
Procedure definition
While executing
Output parameters return single values (not result sets)
Useful for:
Counts
Status flags
Calculated values
Interview Questions
What is an output parameter?
Difference between OUTPUT and RETURN?
Can we have multiple output parameters?
When to use OUTPUT vs SELECT?
Output parameters allow a stored procedure to return values back to the calling code using variables.