difference between output and returnValue sqlParameter ?

  • Thread starter Thread starter bob6
  • Start date Start date
B

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