| title | CLR User-Defined Functions | |||||
|---|---|---|---|---|---|---|
| description | SQL Server CLR integration allows you to create user-defined scalar-valued, table-valued, and aggregate functions in any .NET Framework programming language. | |||||
| author | rwestMSFT | |||||
| ms.author | randolphwest | |||||
| ms.date | 12/27/2024 | |||||
| ms.service | sql | |||||
| ms.subservice | clr | |||||
| ms.topic | reference | |||||
| helpviewer_keywords |
|
[!INCLUDE SQL Server]
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 [!INCLUDE c-sharp-md] or [!INCLUDE visual-basic-md] .NET, to use on [!INCLUDE ssnoversion-md].
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.
| Article | 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 [!INCLUDE tsql] and common language runtime (CLR) TVFs. |
| CLR user-defined aggregates | Describes how to implement and use user-defined aggregates. |