Export (0) Print
Expand All

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.

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.

Community Additions

ADD
Show:
© 2014 Microsoft