Re: getdate() in UDF

From: Delbert Glass (delbert_at_noincoming.com)
Date: 03/25/04 

Date: Thu, 25 Mar 2004 15:10:47 -0600

Let me put some things closer together
so a question does not get lost.

---------

The item maked [2], is of interest to the
discussion earlier in the thread.

* The body of the function references no database objects
outside the scope of the function.
For example, a deterministic function cannot reference
tables other than table variables that are local to the function.
[2]

Built-in nondeterministic functions are not allowed
in the body of user-defined functions.

---------

Why outlaw using "Built-in nondeterministic functions"
in *all* user-defined functions rather than allow them
but mark the utilizing user-defined function as nondeterministic
just like is done whenever tables other than
table variables that are local
to the [utilizing user-defined] function
are referenced?

Or vise versa: Why aren't references to such tables
outlawed for all user-defined functions
just like is done for
"Built-in nondeterministic functions"?

---------

Bye,
Delbert Glass