Understanding User-defined Functions

Like functions in programming languages, Microsoft SQL Server 2005 user-defined functions are routines that accept parameters, perform an action, such as a complex calculation, and return the result of that action as a value. The return value can either be a single scalar value or a result set.

In This Section

Topic Description

User-defined Function Basics

Describes the benefits and components of user-defined functions.

Types of Functions

Lists the types of functions available in SQL Server 2005 and provides references to additional information.

See Also

Other Resources

User-defined Functions (Database Engine)
Designing User-defined Functions
Implementing User-defined Functions

Help and Information

Getting SQL Server 2005 Assistance