Chapter 3. Exploring SQL CLR

Andrew Brust

The banner headline for Microsoft SQL Server 2005 was its integration of the Microsoft .NET common language runtime (CLR). This architectural enhancement gave SQL Server the ability to use certain .NET classes as basic data types, as well as accommodate the use of .NET languages for the creation of stored procedures, triggers, functions, and even user-defined aggregates.

This capability was carried forward and enhanced in SQL Server 2008 and is the underlying enabler of various “beyond relational” SQL Server data types, including hierarchyid (covered in Chapter 7), and geometry and geography (covered in Chapter 9). SQL CLR technology remains important in SQL Server 2012 and we will cover the technology, ...

Get Programming Microsoft® SQL Server® 2012 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.