This presentation covers both types (T-SQL and SQLCLR) user- defined functions in SQL Server 2005. Differences with SQL Server 2000 are pointed out as they are encountered
- How to create and use the three types of UDFs:
- Scalar
- Inline
- Multi-statement or Table-Valued
- How to use 3 types of SQL CLR functions:
- Scalar
- Tabled Valued
- User Defined Aggregate
- Using CROSS APPLY and OUTER APPLY
- Performance issues are a major part of the discussion. They can be a problem with a UDF.
- Permissions to use UDFs are discussed
- How to debug UDFs in SQL Server 2005 and 2000
I gave when Transact-SQL User-Defined Functions was first published follow this link