SQL CLR orSQLCLR (SQLCommon Language Runtime) is technology for hosting of the Microsoft .NET common language runtime engine within SQL Server. The SQLCLR allowsmanaged code to be hosted by, and run in, theMicrosoft SQL Server environment.

This technology, introduced in Microsoft SQL Server 2005, allow users for example to create the following types of managed code objects in SQL Server in .NET languages such asC# orVB.NET.

• Stored procedures (SPs) which are analogous toprocedures orvoid functions in procedural languages like VB or C,
• Triggers which are stored procedures that fire in response toData Manipulation Language (DML) orData Definition Language (DDL) events,
• User-defined functions (UDFs) which are analogous to functions in procedural languages,
• User-defined aggregates (UDAs) which allow developers to create custom aggregates that act on sets of data instead of one row at a time,
• User-defined types (UDTs) that allow users to create simple or complex data types which can be serialized and deserialized within the database.

The SQL CLR relies on the creation, deployment, and registration ofCLI assemblies, which are physically stored in managed code dynamic load libraries (DLLs). These assemblies may contain CLI namespaces, classes, functions and properties.

• Microsoft Docs: Common Language Runtime Integration Overview (Latest version)
• MSDN: Using CLR Integration in SQL Server 2005 (Provides the perspective at the time of the initial release.)

Thisdatabase software-related article is astub. You can help Wikipedia byexpanding it.

• v
• t
• e

• SQL
• Microsoft database software
• .NET
• Database software stubs

• Articles with short description
• Short description matches Wikidata
• All stub articles