SQL CLR: Difference between revisions

Revision as of 03:33, 28 December 2007

Revision as of 09:03, 9 January 2008

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.

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 (SPs) which are analogous to ''procedures'' or ''void functions'' in procedural languages like VB or C,