User Defined Functions (UDF’s) are just about my favorite thing in SQL 2000.I thought the possibilities to be endless, until I realized that they were designed to be completely deterministic:each call to a UDF with the same arguments should always return the same value, and during the evaluation of a UDF it cannot make any changes to the state of the database.
Read more →