SQL CLR: Difference between revisions

Revision as of 09:34, 6 November 2017

Latest revision as of 21:49, 9 March 2021

(7 intermediate revisions by 7 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.

Line 7 ⟶ 8:

*[[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 compwlexcomplex 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==

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