SQL CLR: Difference between revisions

Revision as of 17:21, 11 April 2006

Latest revision as of 21:49, 9 March 2021

(38 intermediate revisions by 32 users not shown)

Line 1:

{{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]] into environmentbe ofhosted by, and run in, the [[Microsoft SQL Server]] environment.

This technology, introduced in Microsoft SQL Server 2005, allow users for example to writecreate [[Stored_procedure|storedthe procedures]]following ortypes userof definedmanaged typescode 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,

{{stub}}

*[[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}}