Re: [SQL] function parameters/output values

Chapter 4 of the programmer's guide.

On 2000-01-12, Thomas Leavitt mentioned:

> I would like to know if function parameters are used to pass output values
> back to the function.
>
> e.g.
>
> create function func1(p1 varchar,p2 varchar OUTPUT, p3 varchar OUTPUT)
> BEGIN
> SELECT p1 = t.foo1, p3 = t.foo2
> FROM test_table t
> WHERE foo3 = p1
> END
>
> DECLARE p2 varchar(50), p3 varchar(50)
> CALL func1('abc',@p2 out,@p3 out)
> PRINT @p2
> PRINT @p3
> --
> Thomas Leavitt -- thomas(dot)leavitt(at)clickrebates(dot)com; 408-591-3342
> Co-Founder/COO, ClickRebates.Com, Inc. (www.clickrebates.com)
> Get Paid What You're Worth!
>
> Sign up for our pre-launch guest list and refer your friends!
>
> Or use our working prototype at www.clickrebates.org to "Surf for a Higher
> Cause" (earn money for charity)
>
>
> ************
>
>

--
Peter Eisentraut Sernanders väg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden