Where do we need to use output parameter in a stored procedure?
Does anyone have any real time experience to share?
I searched a lot but not able to understand proper use of output parameter.
There are several good answers already, but one not mentioned is when you need the procedure to return more than one variable.
Example: Searching for the highest salary a procedure might also return the I.D. of the person and whether they are still employed.