Abstract
Each new version of SQL Server features improvements to T-SQL that make development easier. SQL Server 2000 introduced the concept of user-defined functions (UDFs). Like functions in other programming languages, T-SQL UDFs offer a convenient way for developers to define procedural 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, multistatement table-valued functions, and scalar functions. In this chapter I will talk about T-SQL UDFs. SQL Server 2005 also adds the ability to create SQLCLR UDFs, which I talk about in Chapter 14.
Sign-in/Register to access full text options 
Free) 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a call
