Deterministic functions always returns the same output result all the time it is executed for same input values. i.e. ABS, DATEDIFF, ISNULL etc.
Nondeterministic functions may return different results each time they are executed. i.e. NEWID, RAND, @@CPU_BUSY etc. Functions that call extended stored procedures are nondeterministic. User-defined functions that create side effects on the database are not recommended.
Reference : Pinal Dave (http://blog.SQLAuthority.com)
[...] SQL SERVER – Deterministic Functions and Nondeterministic Functions [...]
Hello Pinal
can i have more example of non deterministic function which are taking parameters.
i have on doubt?
can we call a non determenistic funtion in our user defined function..if not why?
can we call a non determenistic funtion from our user defined function..if not why?