User Defined Function

V

vicoluf

Hello

How do you call a user defined function stored on a SQL 2000 serve
from MS Access database (mdb)?. The function should return a table o
a scalar value

Thanks

Victo
 
D

Duane Hookom

You should be able to use a pass-through query. These use the SQL Server
syntax.
 
D

Dirk Goldgar

vicoluf said:
Hello,

How do you call a user defined function stored on a SQL 2000 server
from MS Access database (mdb)?. The function should return a table or
a scalar value.

Thanks.

Victor
Click to expand...

I imagine you'd use a pass-through query. Send the required T-SQL
statement(s) right through to SQL Server, get the records back. But if
you want to pass parameters to the function, it would be a bit more
complicated. You might have to rewrite the query's SQL dynamically.
 
V

vicoluf

Thank you all very much for your approach.

If I've already stored this function on the server is there any way
could call the fuction with parameters from mdb file? ... just lik
I'd call any stored procedur

Victo
 
D

Duane Hookom

Did you understand both replies that suggested you use a pass-through query?
 
Top