Abstract
Functions were introduced in SQL Server 2000 and made an immediate impact. Functions allow you to wrap up pieces of code you use all the time into a nice, compact, reusable package. In this chapter, we’ll find out what types of function SQL Server allows us to create, why functions are useful, and how we can improve our code with functions. We’ll also see some of the system functions SQL Server provides. By the end of this chapter, we’ll know all about scalar functions, and we’ll be ready to talk about table-valued functions (TVFs) in Chapter 17. We’ll be half-functional!
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
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2015 Mike McQuillan
About this chapter
Cite this chapter
McQuillan, M. (2015). Functions. In: Introducing SQL Server. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1419-0_16
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1419-0_16
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-1420-6
Online ISBN: 978-1-4842-1419-0
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books