Skip to main content
Book Chapter

User-Defined Functions and Types

  • Brimhall J
  • Dye D
  • Gennick J
  • et al.
Apress, (2012), 383-413
DOI: 10.1007/978-1-4302-4201-7_18
N/ACitations
Citations of this article
1Readers
Mendeley users who have this article in their library.
Get full text

Abstract

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 system data type, enforcing a specific data type, length, and nullability.

Cite

CITATION STYLE

APA

Brimhall, J., Dye, D., Gennick, J., Roberts, A., & Sheffield, W. (2012). User-Defined Functions and Types. In SQL Server 2012 T-SQL Recipes (pp. 383–413). Apress. https://doi.org/10.1007/978-1-4302-4201-7_18

Register to see more suggestions

Mendeley helps you to discover research relevant for your work.

Already have an account?

Save time finding and organizing research with Mendeley

Sign up for free