Your First SQL CLR Stored Procedure
Although SQL CLR programming can get quite complex and involved, in reality it offers 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 2012 to load .NET assemblies into your database and then allow you to use the functions and types within the assembly as you define your columns, views, stored procedures, triggers, and functions.
To gain a good understanding of SQL CLR integration, you 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. This ...
Get Programming Microsoft® SQL Server® 2012 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
