sql server odbc: possible to call a table valued User Defined Function thru ODBC -- sql server odbc

possible to call a table valued User Defined Function thru ODBC

fpdave
1/20/2005 6:19:29 AM

sql server odbc:

I want to be able to call a SQL Server User Defined Function that is a
table valued UDF. I have existing code that uses ODBC and calling UDFs
is going to be a lot easier than calling stored procedures, as the
syntax is close to using a table itself (at least in T-SQL it is).

But, I suspect that only scalar-valued functions can be called, but
please tell me otherwise.

Re: possible to call a table valued User Defined Function thru ODBC

Robbe Morris
2/3/2005 10:04:18 PM

I don't believe you can return a TABLE variable from a UDF
directly through to ODBC.

How is calling a UDF simpler than calling a stored procedure?

By the way, if you want the database layer written for you in
ADO.NET (if you are using .NET...), you can use this code
generator (source code included).

http://www.eggheadcafe.com/articles/adonet_source_code_generator.asp

--
2005 Microsoft MVP C#
Robbe Morris
http://www.masterado.net
http://www.mastervb.net

[quoted text, click to view]