Using CLR Integration in SQL Server 2005

By Bill Graziano on 29 November 2004 | 4 Comments | Tags: SQL Server 2005, CLR


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. This is a great whitepaper on when to use the CLR vs when to use T-SQL. Lots of performance issues discussed. Follow the link to Using CLR Integration in SQL Server 2005...

Discuss this article: 4 Comments so far. Print this Article.

If you like this article you can sign up for our weekly newsletter. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Related Articles

Handling SQL Server Errors (5 April 2010)

Microsoft Releases Updated SQL Server 2005 SP2 (6 March 2007)

SQL Server 2005 SP2 Available (19 February 2007)

SQL Server 2005 Service Pack 2 CTP is Available (8 November 2006)

SQL Server 2005 SP1 (19 April 2006)

SQL Server 2005 RTM Code Available (27 October 2005)

Writing CLR Stored Procedures in C# - Returning Data (Part 2) (23 June 2005)

SQL Server 2005 Release Date - November 7th, 2005 (7 June 2005)

Other Recent Forum Posts

From Litespeed task to Networker (1 Reply)

sp_help and object explorer showing different (4 Replies)

SQL server installation issues (12 Replies)

Clustered Index Scan Nightmare (4 Replies)

SQL named instance cannot be connected (5 Replies)

select with Header and detail (1 Reply)

Help with string (4 Replies)

SPROC paging and sorting issue (0 Replies)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -