Pro T-SQL 2008 Programmer's Guide

Chapter 14. SQL CLR Programming

One of the most prominent enhancements to SQL Server 2005 was the introduction of the integrated SQL Common Language Runtime (SQL CLR). SQL CLR is a SQL Server-specific version of the .NET Common Language Runtime, which allows you to run .NET managed code in the database. SQL CLR programming is a broad subject that could easily fill an entire book, and in fact it doesPro SQL Server 2005 Assemblies, by Robin Dewson and Julian Skinner (Apress, 2005), is an excellent resource for in-depth coverage of SQL CLR programming. In this chapter, I'll discuss the methods used to extend SQL Server functionality in the past, and explain the basics of the SQL CLR programming model and the improvements made to SQL CLR in SQL Server ...