imported>JJMC89 bot III: Moving :Category:.NET Framework to :Category:.NET per Wikipedia:Categories for discussion/Log/2021 February 18#Category:.NET Framework

2021-03-09T21:49:32Z

Moving Category:.NET Framework to Category:.NET per Wikipedia:Categories for discussion/Log/2021 February 18#Category:.NET Framework

New page

{{short description|Technology for hosting of the Microsoft .NET common language runtime engine within SQL Server.}}
'''SQL CLR''' or '''SQLCLR''' ([[SQL]] [[Common Language Runtime]]) is technology for hosting of the Microsoft .NET common language runtime engine within SQL Server. The SQLCLR allows [[managed code]] 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 Sharp (programming language)|C#]] or [[VB.NET]].

*[[Stored procedure]]s (SPs) which are analogous to ''procedures'' or ''void functions'' in procedural languages like VB or C,
*[[Database trigger|Triggers]] which are stored procedures that fire in response to [[Data Manipulation Language]] (DML) or [[Data Definition Language]] (DDL) events,
*[[User-defined function]]s (UDFs) which are analogous to functions in procedural languages,
*[[User-defined aggregate]]s (UDAs) which allow developers to create custom aggregates that act on sets of data instead of one row at a time,
*[[User-defined type]]s (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 [[Assembly (CLI)|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==
*[https://docs.microsoft.com/en-us/sql/relational-databases/clr-integration/common-language-runtime-integration-overview Microsoft Docs: Common Language Runtime Integration Overview] (Latest version)
*[http://msdn2.microsoft.com/en-us/library/ms345136.aspx MSDN: Using CLR Integration in SQL Server 2005] (Provides the perspective at the time of the initial release.)

{{.NET Framework}}

{{DEFAULTSORT:Sql Clr}}
[[Category:SQL]]
[[Category:Microsoft database software]]
[[Category:.NET]]

{{database-software-stub}}

SQL CLR - Revision history

imported>JJMC89 bot III: Moving :Category:.NET Framework to :Category:.NET per Wikipedia:Categories for discussion/Log/2021 February 18#Category:.NET Framework