SQL CLR: Difference between revisions

Revision as of 17:23, 11 April 2006

Revision as of 04:05, 22 October 2006

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]] into environmentbe ofhosted by, and run in, the [[Microsoft SQL Server]] environment.

This technology, introduced in Microsoft SQL Server 2005, allow users for example to writecreate [[Stored_procedure|storedthe procedures]]following ortypes userof definedmanaged typescode objects in SQL Server in .NET languages such as [[C#]] or [[VB.NET]].

: [[Stored_procedure|stored procedures]] (SP's) which are analagous to ''procedures'' or ''void functions'' in procedural languages like VB or C,

: [[Triggers|triggers]] which are stored procedures that fire in response to [[Data Manipulation Language|Data Manipulation Language]] (DML) or [[Data Definition Language|Data Definition Language]] (DDL) events,

: [[user-defined functions|user-defined functions]] (UDF's) which are analagous to functions in procedural languages,

: [[user-defined aggregates|user-defined aggregates]] (UDA's) which allow developers to create custom aggregates that act on sets of data instead of one row at a time,

: [[user defined types|user defined types]] (UDT's) 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.

{{compsci-stub}}