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

• 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