Using CLR Integration in SQL Server 2005 - from Only4Gurus.com

Using CLR Integration in SQL Server 2005 - from Only4Gurus.com:

"This paper describes how database application developers and architects can take advantage of the CLR integration features in SQL Server 2005. It compares CLR-based programming with existing programming models supported in SQL Server, such as Transact-SQL and extended stored procedures, and highlights the relative strengths and weaknesses of each. It also provides a set of high-level guidelines to pick the appropriate programming alternative, and a set of examples and code samples."

CLR integration is one of the most significant new features in SQL Server 2005. In a nutshell, it allows you to break out of T-SQL, the native scripting language for stored procedures, and write stored procedures in just about any language you choose (over 20 of them).