returning parameters in functions

returning parameters in functions

Post by Lorenzo Brunell » Thu, 09 May 2002 20:10:05

Hello everybody,

I'd like to know if is it possible to get a set of rows with many fields (of
different type) from a function which implements a SELECT query?



1. Return values (stored functions) and named parameters

Does anyone know how to get values from stored functions {?=call
stp(?,?,?) }.  I cannot find any documentation on how to get the value back!

I would like to also to know how to implement named parameters.  Is it by
using setString( 50, "foo" )?

We are using MS-SQL 6.5 sp3, FastForward JDBC drivers, NT 4.0 sp3 server.

If anyone has any info on this, I would be very grateful for some help here.

Thanks a ton in advance.

Bob Doppel

2. Linux Problem

3. user-defined functions that return a table can't takes getdate() as parameters

4. Log Shipping - Not copying or loading

5. Calling a stored function that returns a boolean and two OUT parameters

6. Helo with Indexes!!!

7. Stored procedure returning empty output parameters or return value

8. Return result set and return value/output parameter

9. Calling a function with a function as a parameter

10. function parameters as functions

11. return datediff function from user defined function.

12. Return Parameter from Stored procedure