Research work · 2008
User-Defined Functions
Apress eBooks
Abstract
Each new version of SQL Server features improvements to T-SQL that make development easier. SQL Server 2000 introduced (among other things) the concept of user-defined functions (UDFs). Like functions in other programming languages, T-SQL UDFs provide a convenient way for developers to define routines that accept parameters, perform actions based on those parameters, and return data to the caller. T-SQL functions come in three flavors: inline table-valued functions (TVFs), multistatementTVFs, and scalar functions. SQL Server 2008 also supports the ability to create SQL CLR UDFs, which I’ll talk about in Chapter 14.