User-Defined Functions and Types

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

Keywords

Shipping Product Line Prefix Sonal 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Joseph Sack 2008

Personalised recommendations