By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,996 Members | 1,095 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,996 IT Pros & Developers. It's quick & easy.

Can i call an UDF (user defined function ) on an MSDE2000 server from code ?

P: n/a
Hi

How can i call an UDF in an SQL database ? ,i tried ExecuteScalar ,but
without luck

Johan
May 14 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"Sagaert Johan" <RE*************@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl...
| Hi
|
| How can i call an UDF in an SQL database ? ,i tried ExecuteScalar ,but
| without luck
|
| Johan
|
|

Say you have a UDF Function1 that takes an int and returns an int, then you
can execute it using following select.

SELECT dbo.Function1(2)

this returns a single row holding the int field.

Willy.
May 14 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.