What’s New for SQLCLR in SQL Server 2008

Although there are only a few changes to SQLCLR in SQL Server 2008, including support for multiparameter aggregates, support for large-value data types (such as nvarchar(MAX)) and support for the new SQL Server 2008 data types (such as date and time), SQLCLR itself introduces a wealth of new possibilities for developing with .NET and SQL Server that you should consider leveraging in your data-driven applications.

In the following sections, we give you all the tools you need to write your own stored procedures, functions, triggers, data types, and aggregate functions in C# or VB .NET.

Get Microsoft® SQL Server 2008 R2 Unleashed 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.