SQL CLR: Difference between revisions

Revision as of 17:57, 26 June 2012

Latest revision as of 21:49, 9 March 2021

(11 intermediate revisions by 10 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 4 ⟶ 5:

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

Line 12 ⟶ 13:

==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]]