difference between output and returnValue sqlParameter ?

[bob6]

Hello !

Can someone please explain to me what the difference between "output"
and "returnValue" as direction for sqlParameter in a stored Procedure
?

Thanks,
Lanz

 

[William Ryan]

You can pass back an entire record or cursor with Output params.

Every Stored Proc you fire returns a return code to the caller, and you can
control this manually with a return value. Even if you don't set them, they
still come back albiet they'll be 0.

HTH,

Bill

 

[Bob Bob]

Thanks Bill !