Abstract
SQL Server 2000 provides two types of functions: built-in and user-defined. Chapter 6 covered some of the commonly used built-in functions, and this chapter focuses on the user-defined type. The ability to create user-defined functions has been on developers’s wish lists for several releases of SQL Server. Now that the functionality exists, let’s see if we can learn how it can be used to write more efficient T-SQL statements.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2001 Garth Wells
About this chapter
Cite this chapter
Wells, G. (2001). User-Defined Functions. In: Code Centric: T-SQL Programming with Stored Procedures and Triggers. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-1145-7_7
Download citation
DOI: https://doi.org/10.1007/978-1-4302-1145-7_7
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-893115-83-5
Online ISBN: 978-1-4302-1145-7
eBook Packages: Springer Book Archive