call a user defined function from another user-defined function 
Author Message
 call a user defined function from another user-defined function
hi, there
can i call a user-defined function from another user-defined function. when
i tried to do so, sql server showed error message saying that "function_name
is not a recoginzed function".
please help.

--
Wang



Sat, 14 Jan 2006 09:09:47 GMT
 call a user defined function from another user-defined function

No you cannot.  Read in BOL about UDF determinism.  A UDF must be
deterministic ... i.e. it cannot use GetDate because GetDate is not
deterministic (It returns a different value everytime).  So I would
assume that the UDF you are calling from within your UDF is
non-deterministic.

V/R Jim Johnston
MCSD, MCDBA

Quote:

> hi, there
> can i call a user-defined function from another user-defined function. when
> i tried to do so, sql server showed error message saying that "function_name
> is not a recoginzed function".
> please help.



Mon, 16 Jan 2006 14:16:11 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. calling access querydef that calls a user defined access function

2. Can't use execute function in MSSQL user-define function

3. return datediff function from user defined function.

4. Built in function =user define function

5. scalar user-defined function require the function to be owner qualified

6. Instrinsic function inside user-defined function?

7. Instrinsic function in User-defined function

8. recovering user defined function which is now a system function

9. Mixed case function or How to create user defined function

10. Optimizing calls to user-defined functions

11. Newbie - Calling a user-defined function

12. How to call User Defined Function in SQL Server through VB


 
Powered by phpBB® Forum Software