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 instructio ...
) 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 Runti ...
to be hosted by, and run in, the
Microsoft 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 as
C# or
VB.NET
Visual Basic, originally called Visual Basic .NET (VB.NET), is a multi-paradigm, object-oriented programming language, implemented on .NET, Mono, and the .NET Framework. Microsoft launched VB.NET in 2002 as the successor to its original Visua ...
.
*
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 dic ...
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 (DML) or
Data 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 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