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 is carried forward and enhanced in SQL Server 2008. It also is the underlying enabler of various new SQL Server 2008 data types, including geometry and geography, covered in Chapter 9.

Note

Note

Throughout this chapter, we will refer ...

Get Programming Microsoft® SQL Server™ 2008 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.