output or inputoutput?

  • Thread starter Thread starter Brent
  • Start date Start date
B

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
 
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
 
Back
Top