Share via


Designing User-defined Functions

A user-defined function is stored as a database object providing reusable code. This section provides the information you need to design user-defined functions.

In This Section

Topic Description

User-defined Function Design Guidelines

Provides guidelines for choosing the type of user-defined functions and evaluating the properties of the function.

Table-valued User-defined Functions

Describes table-valued user-defined functions and provides examples of creating and invoking this type of function.

Inline User-defined Functions

Describes table-valued user-defined functions and provides examples of creating and invoking this type of function

Deterministic and Nondeterministic Functions

Compares inline user-defined functions to parameterized views and provides examples.

Rewriting Stored Procedures As Functions

Provides guidelines on when to rewrite existing stored procedure logic as user-defined functions.

See Also

Other Resources

Understanding User-defined Functions
Implementing User-defined Functions

Help and Information

Getting SQL Server 2005 Assistance