User Defined Function

  • Thread starter Thread starter vicoluf
  • Start date Start date
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
 
You should be able to use a pass-through query. These use the SQL Server
syntax.
 
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.
 
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
 
Back
Top