O'Reilly logo

Programming Microsoft® SQL Server™ 2008 by Leonard Lobel, Andrew Brust, and Stephen Forte

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Best Practices for SQL CLR Usage

Before we close this chapter, we’d like to summarize certain best practices for the appropriate use of SQL CLR programming.

The CLR integration in SQL Server 2008 is a powerful technology. In some cases, it allows you to do things you can’t do practically in T-SQL (such as apply complex computational logic in stored procedures or triggers), and in other cases, it allows you to do things you can’t do at all in T-SQL (such as create your own aggregate functions).

The fact remains, however, that set-based data selection and modification are much better handled by the declarative constructs in T-SQL than in the procedural constructs of .NET and the ADO.NET object model. SQL CLR functionality should be reserved for specific ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required