SQL CLR: Difference between revisions

Revision as of 14:28, 13 November 2007

Revision as of 03:33, 28 December 2007

Line 3:

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

*[[Stored procedure]]s (SP'sSPs) 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,

*[[User-defined function]]s (UDF'sUDFs) which are analogous to functions in procedural languages,

*[[User-defined aggregate]]s (UDA'sUDAs) 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'sUDTs) 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'sDLLs). These assemblies may contain .NET namespaces, classes, functions and properties.

==External links==