SQL CLR or SQLCLR (
SQL Common Language Runtime
The Common Language Runtime (CLR), the virtual machine component of Microsoft .NET Framework, manages the execution of .NET programs. Just-in-time compilation converts the managed code (compiled intermediate language code) into machine instruc ...
) is technology for hosting of the Microsoft .NET common language runtime engine within SQL Server. The SQLCLR allows
managed code
Managed code is computer program code that requires and will execute only under the management of a Common Language Infrastructure (CLI); Virtual Execution System (VES); virtual machine, e.g. .NET, CoreFX, or .NET Framework; Common Language Runt ...
to be hosted by, and run in, the
Microsoft SQL Server
Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which ...
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 as
C# or
VB.NET.
*
Stored procedure
A stored procedure (also termed proc, storp, sproc, StoPro, StoredProc, StoreProc, sp, or SP) is a subroutine available to applications that access a relational database management system (RDBMS). Such procedures are stored in the database data di ...
s (SPs) which are analogous to ''procedures'' or ''void functions'' in procedural languages like VB or C,
*
Triggers which are stored procedures that fire in response to
Data Manipulation Language
A data manipulation language (DML) is a computer programming language used for adding (inserting), deleting, and modifying (updating) data in a database. A DML is often a sublanguage of a broader database language such as SQL, with the DML com ...
(DML) or
Data Definition Language (DDL) events,
*
User-defined function A user-defined function (UDF) is a function provided by the user of a program or environment, in a context where the usual assumption is that functions are built into the program or environment. UDFs are usually written for the requirement of its c ...
s (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 of
CLI assemblies, which are physically stored in managed code dynamic load libraries (DLLs). These assemblies may contain CLI namespaces, classes, functions and properties.
External links
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.)
SQL
Microsoft database software
.NET
{{database-software-stub