Chapter 3. Exploring SQL CLR
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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
