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?
Thanks
Lorenzo
by Lorenzo Brunell » Thu, 09 May 2002 20:10:05
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?
Thanks
Lorenzo
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
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
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