SQL CLR: Difference between revisions

Content deleted Content added

Inline

Latest revision as of 21:49, 9 March 2021

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# or VB.NET.

Stored procedures (SPs) which are analogous to procedures or void functions in procedural languages like VB or C,
Triggers which are stored procedures that fire in response to Data Manipulation Language (DML) or Data Definition Language (DDL) events,
User-defined functions (UDFs) which are analogous to functions in procedural languages,
User-defined aggregates (UDAs) which allow developers to create custom aggregates that act on sets of data instead of one row at a time,
User-defined types (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 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

Microsoft Docs: Common Language Runtime Integration Overview (Latest version)
MSDN: Using CLR Integration in SQL Server 2005 (Provides the perspective at the time of the initial release.)

This database software-related article is a stub. You can help Wikipedia by expanding it.

@@ Line 1: / Line 1: @@
-'''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.
+{{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|C#]] or [[VB.NET]].
+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 (SP's) which are analogous to ''procedures'' or ''void functions'' in procedural languages like VB or C,
+*[[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,
+*[[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 (UDF's) which are analagous to functions in procedural languages,
+*[[User-defined function]]s (UDFs) which are analogous to functions in procedural languages,
-: [[user-defined aggregate]]s (UDA's) which allow developers to create custom aggregates that act on sets of data instead of one row at a time,
+*[[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 (UDT's) that allow users to create simple or complex data types which can be serialized and deserialized within the database.
+*[[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 .NET ''assemblies'', which are physically stored in managed code dynamic load libraries (DLL's).  These assemblies may contain .NET namespaces, classes, functions and properties.
+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==
+==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://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlclrguidance.asp
+*[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.)
-* [http://blogs.msdn.com/sqlclr/ SQL CLR Team Blog]
-* [http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=45&SiteID=1 .NET Framework Data Access and Storage]
+{{.NET Framework}}
+{{DEFAULTSORT:Sql Clr}}
 [[Category:SQL]]
+[[Category:Microsoft database software]]
+[[Category:.NET]]
-{{compsci-stub}}
+{{database-software-stub}}