1 out of 1 rated this helpful - Rate this topic

Understanding User-defined Functions

SQL Server 2008 R2

SQL Server 2008
SQL Server 2005

Like functions in programming languages, Microsoft SQL Server 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

User-Defined Function Basics: Describes the benefits and components of user-defined functions.
Types of Functions: Lists the types of functions and provides references to additional information.

Other Resources

User-Defined Functions (Database Engine)

Designing User-Defined Functions

Implementing User-defined Functions

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ