Exploring Changes Made to SQL Server 2005's UDF Options![](https://eu-images.contentstack.com/v3/assets/blt07f68461ccd75245/bltdd216621d1fd3060/66277c077963b4a859cefbe5/sqlserver2005-managment-tools-595x335_0_0.jpg?width=700&auto=webp&quality=80&disable=upscale)
Early Versions (SQL Server 2000 – 2008)![](https://eu-images.contentstack.com/v3/assets/blt07f68461ccd75245/bltdd216621d1fd3060/66277c077963b4a859cefbe5/sqlserver2005-managment-tools-595x335_0_0.jpg?width=700&auto=webp&quality=80&disable=upscale)
Exploring Changes Made to SQL Server 2005's UDF OptionsExploring Changes Made to SQL Server 2005's UDF Options
Here's the "input" a new option for SQL Server 2005's UDF function that speeds up the processing of NULL input. Also, SQL Server 2005 lets you use more non-deterministic functions with UDFs.
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.