You can helpexpand this article with text translated fromthe corresponding article in Chinese. (December 2025)Click [show] for important translation instructions.
Machine translation, likeDeepL orGoogle 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.
Consideradding a topic to this template: there are already 388 articles in themain category, and specifying|topic= will aid in categorization.
Do not translate text that appears unreliable or low-quality. If possible, verify the text with references provided in the foreign-language article.
Youmust providecopyright attribution in theedit summary accompanying your translation by providing aninterlanguage link to the source of your translation. A model attribution edit summary isContent in this edit is translated from the existing Chinese Wikipedia article at [[:zh:SQL CLR]]; see its history for attribution.
You may also add the template{{Translated|zh|SQL CLR}} to thetalk page.
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 asC# orVB.NET.[2]
Stored procedures (SPs) which are analogous toprocedures orvoid functions in procedural languages like VB or C,
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 ofCLI assemblies, which are physically stored in managed code dynamic load libraries (DLLs). These assemblies may contain CLI namespaces, classes, functions and properties.
