Advertisement

User Defined Functions

  • Tony Bain
  • Louis Davidson
  • Robin Dewson
  • Chuck Hawkins

Abstract

User defined functions, known more commonly as UDFs, are routines called from T-SQL code to return either a single value or a rowset. Although they are, perhaps, the least used of specialized stored procedures, they are powerful tools in a database developer’s armory. They provide the developer with the ability to create their own customized functions, which can then be re-used in other parts of their T-SQL code.

Keywords

Return Statement Deterministic Function Table Function Select Statement Table Variable 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Apress 2003

Authors and Affiliations

  • Tony Bain
    • 1
  • Louis Davidson
    • 2
  • Robin Dewson
  • Chuck Hawkins
    • 3
  1. 1.Tony Bain & AssociatesUSA
  2. 2.Christian Broadcasting Network and NorthStar StudiosNashvilleUSA
  3. 3.Compass Technology ManagementUSA

Personalised recommendations