if we want something from that method/procedure to return
then use out parameter
1st we call that method with out parameter. then give some
value to that out parameter in procedure and then use that
value...
so to get the required value we use out parameter
A out parameter is a parameter option to pass value to the
calling function. If a function needs to return multiple
values to the calling function the it is best to use out
parameter whereas return parameter can be used for
returning only one value.
An out parameter should be marked with an out keyword, and
the parameter should be initialized inside the function.
methods cannot have out parameters only parameters with ref
or value can be passed to method/function
When we talk about procedures in Sql server we can have out
parameters. They are mainly used when you want to return
multiple values and non numeric values from the sql
procedures
They are usefull when you are calling a procedure from
another procedure and need some specfic values
Out Parameter: Used to pass a parameter as a reference so
that the function called will set the value. This could be
used to return more than 1 value by a function.
e.g.
public int AddMuliply( int a int b out int c)
{
c a*b;
return ( a+b);
}