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), multistatement TVFs, and scalar functions. SQL Server 2014 also supports the ability to create CLR integration UDFs, which are discussed in Chapter 15.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
Robert L. Taft, “Name Search Techniques,” Special Report (Albany, NY: Bureau of Systems Development, 1970).
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2015 Miguel Cebollero
About this chapter
Cite this chapter
Cebollero, M., Natarajan, J., Coles, M. (2015). User-Defined Functions. In: Pro T-SQL Programmer's Guide. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0145-9_4
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0145-9_4
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0146-6
Online ISBN: 978-1-4842-0145-9
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books