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

Your First SQL CLR Stored Procedure

Although SQL CLR programming can get quite complex and involved, it offers in reality a simple model that any .NET developer can use with high productivity in relatively short order. That’s because the crux of SQL CLR functionality is nothing more than the ability of SQL Server 2008 to load .NET assemblies into your database and then to allow you to use the functions and types within those assemblies as you define your columns, views, stored procedures, triggers, and functions.

To give you a good understanding of SQL CLR integration, we must examine its features and techniques carefully. Before doing so, however, let’s quickly walk through an end-to-end scenario for creating and executing a SQL CLR stored procedure. ...

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