Monday, April 26, 2010

Functions (UDF) in SQL Server 2005

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