Export (0) Print
Expand All
2 out of 3 rated this helpful - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.