User-Defined Functions and Types
In this chapter, I’ll present recipes for user-defined functions and types. User-defined functions (UDFs) allow you to encapsulate both logic and subroutines into a single function that can then be used within your Transact-SQL queries and programmatic objects. User-defined types (UDTs) allow you to create an alias type based on an underlying systemdata type, enforcing a specific data type, length, and nullability.
KeywordsData Type Database Object Syntax Element Create Function Select Clause
Unable to display preview. Download preview PDF.