SQL CLR: Difference between revisions

Revision as of 15:31, 1 November 2010

Latest revision as of 21:49, 9 March 2021

(12 intermediate revisions by 11 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]] 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|triggersTriggers]] 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 [[.NETAssembly (CLI)|CLI assemblies]], which are physically stored in managed code dynamic load libraries (DLLs). These assemblies may contain .NETCLI namespaces, classes, functions and properties.

==External links==

* [httphttps://msdn2docs.microsoft.com/en-us/librarysql/ms345136.aspxrelational-databases/clr-integration/common-language-runtime-integration-overview MSDNMicrosoft Docs: UsingCommon CLRLanguage Runtime Integration inOverview] SQL(Latest Server 2005]version)

* [http://forumsmsdn2.microsoft.com/MSDNen-us/library/ShowForumms345136.aspx?ForumID=86&SiteID=1 MSDN: ForumUsing onCLR .NET FrameworkIntegration in SQL Server 2005] (Provides the perspective at the time of the initial release.)

* [http://www.sqlclr.net/ SqlClr.net Independent site]

{{.NET Framework}}

* [http://blogs.msdn.com/sqlclr/ SQL CLR Team Blog (No posts since 2006, might be dead)]

{{DEFAULTSORT:Sql Clr}}

[[Category:SQL]]

[[Category:Microsoft database software]]

[[Category:.NET framework]]

{{database-software-stub}}

[[cs:SQL CLR]]

[[zh:SQL CLR]]