output or inputoutput?

17 Mar 2006 3:06 PM

Brent

When specifying the parameter direction for sqlserver should you use
inputoutput or ouput if your not going to passing anything into the
parameter? In 99% of the cases where i use output params; i don't pass
anything into them. I know sql server output params are really input/output
variables but i didn't know if you weren't going to pass anything into them
if just specifying output would either be more effecient or safer.

thanks,
Brent

21 Mar 2006 12:41 AM

Mary Chipman [MSFT]

I doubt that it matters much which one you use. In terms of
efficiency, any difference between output and input/output for a
single parameter would probably be so infinitesimal as to be
undetectable. The only potential safety issue I can see would be if
you were not validating input parameter values.

--Mary

Show quote

On Fri, 17 Mar 2006 09:06:53 -0600, "Brent" <brentwa@spam.hotmail.com>
wrote:

>When specifying the parameter direction for sqlserver should you use
>inputoutput or ouput if your not going to passing anything into the
>parameter? In 99% of the cases where i use output params; i don't pass
>anything into them. I know sql server output params are really input/output
>variables but i didn't know if you weren't going to pass anything into them
>if just specifying output would either be more effecient or safer.
>
>thanks,
>Brent
>