User-defined functions

User-defined functions are routines that can take parameters, perform calculations or other

actions, and return a result. You can write user-defined functions in any.NET Framework

programming language, such as C# or Visual Basic.NET, to use on SQL Server.

There are two types of functions:

scalar

, which returns a single value, and

table-valued

, which

returns a set of rows.

The following table lists the articles in this section.

Description

CLR scalar-valued

functions

Covers implementation requirements and examples of scalar-valued functions.

CLR table-valued

functions

Discusses how to implement and use table-valued functions (TVFs), as well as

differences between Transact-SQL and common language runtime (CLR) TVFs.

CLR user-defined

aggregates

Describes how to implement and use user-defined aggregates.

User-defined functions

ﾉ

Expand table