SQL CLR

Short description: Microsoft database software technology

This article has multiple issues. Please help improve it or discuss these issues on the talk page. (Learn how and when to remove these template messages)

This article includes a list of references, related reading or external links, but its sources remain unclear because it lacks inline citations. Please help to improve this article by introducing more precise citations. (December 2025) (Learn how and when to remove this template message)

|

Template:Only primary sources

You can help expand this article with text translated from the corresponding article in 中文.  (December 2025) Click [show] for important translation instructions.

*   * Machine translation, like DeepL or Google Translate, is a useful starting point for translations, but translators must revise errors as necessary and confirm that the translation is accurate, rather than simply copy-pasting machine-translated text into the English Wikipedia.
* Do not translate text that appears unreliable or low-quality. If possible, verify the text with references provided in the foreign-language article.
* You must provide copyright attribution in the edit summary accompanying your translation by providing an interlanguage link to the source of your translation. A model attribution edit summary is `Content in this edit is translated from the existing 中文 Wikipedia article at [[:zh:Exact name of the 中文 article]]; see its history for attribution.`
* You may also add the template `{{Translated page|zh|Exact name of 中文 article}}` to the talk page.
* For more guidance, see Wikipedia:Translation.

|

(Learn how and when to remove this template message)

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.[1]

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.[2]

* 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.

## References

1. ↑ rwestMSFT. "Common Language Runtime (CLR) Programming - SQL Server" (in en-us). https://learn.microsoft.com/en-us/sql/relational-databases/clr-integration/common-language-runtime-clr-integration-programming-concepts?view=sql-server-ver17.
2. ↑ rwestMSFT. "Use Common Language Runtime (CLR) Integration to Build Database Objects - SQL Server" (in en-us). https://learn.microsoft.com/en-us/sql/relational-databases/clr-integration/database-objects/building-database-objects-with-common-language-runtime-clr-integration?view=sql-server-ver17.

## 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.)

* v
* t
* e

.NET Framework

* Version history
* .NET strategy

Architecture|

* Common Language Runtime (CLR)
* COM Interop
* Framework Class Library (FCL)

Components|

* ADO.NET
* Entity Framework
* ASP.NET
* Web Forms
* AJAX
* Core
* Dynamic Data
* MVC
* Razor
* ClickOnce
* Dynamic Language Runtime
* Extensible Application Markup Language (XAML)
* Language Integrated Query (LINQ)
* Managed Extensibility Framework
* Microsoft Silverlight
* Microsoft XNA
* Parallel Extensions
* Windows Communication Foundation (WCF)
* WCF Data Services
* Windows Forms (WinForms)
* Windows Identity Foundation (WIF)
* Windows Presentation Foundation (WPF)
* Windows Workflow Foundation (WF)
* .NET Remoting

Tools|

| Decompilers|

* .NET Reflector
* dotPeek

|

Obfuscators|

* Dotfuscator
* SmartAssembly
* CodeArmor

Misc|

* CLR Profiler
* ILAsm
* .NET Compiler Platform
* Native Image Generator (NGen)
* XAMLPad

IDEs|

* Visual Studio
* Blend
* Express
* MonoDevelop
* SharpDevelop
* Xamarin Studio

Organizations|

* .NET Foundation
* Microsoft
* Xamarin

* Category
* List

0.00

(0 votes)

Original source: https://en.wikipedia.org/wiki/SQL CLR. Read more

|

Retrieved from "https://handwiki.org/wiki/index.php?title=SQL_CLR&oldid=4219731"
*[v]: View this template
*[t]: Discuss this template
*[e]: Edit this template