UDF that return non-deterministic values are not allowed to be called from inside UDFGETDATE is an example of a non-deterministic function. Every time the function is called, a different value is returned.Not every SQL statement or operation is valid within a function.The following lists enumerate the valid and invalid function operations:Valid:Assignment statementsControl-flow statementsVariable declarationsSELECT statements that modify local variablesCursor operations that fetch into local variablesINSERT, UPDATE, DELETE statement that act upon local table variablesInvalid:Built-in, nondeterministic functions such as GetDate()Statements that update, insert, or delete tables or viewsCursor fetch operations that return data to the client
- 0
