Using the .NET Framework for SQL Server Program...

Using the .NET Framework for SQL Server Programming

Microsoft SQL Server 2005 features the integration of the common language runtime (CLR) component of the .NET Framework for Microsoft Windows. For SQL Server programming, this means you can write stored procedures, triggers, user-defined types, user-defined functions, user-defined aggregates, and streaming table-valued functions using any .NET Framework language, including Microsoft Visual Basic .NET and Microsoft Visual C#.

Using CLR Integration in SQL Server 2005 Programming
Compare CLR-based programming models with SQL Server programming models such as Transact SQL and extended stored procedures. Get tips on how to choose a model, code samples, and more.

SQL Server Programming Articles and Columns

Processing XML Showplans Using SQL CLR in SQL Server 2005
Build a SQLCLR application to display a query's estimated execution cost from its XML showplan, which you can use to restrict query submission and avoid server overload.
Using Table Valued Functions in SQL Server 2005 to Implement a Spatial Data Library
Discover how to add spatial search functions (point-near-point and point in polygon) to Microsoft SQL Server 2005 using C# and table-valued functions. It is possible to use this library to add spatial search to your application without writing any special code.

Webcasts

SQL Server Programming Resources in Books Online

Introduction to Common Language Runtime (CLR) Integration
Discover the CLR and see how and why this technology has been used in SQL Server and the benefits of using the CLR to create database objects.
Building Database Objects with Common Language Runtime (CLR) Integration
See what kinds of objects you can build using the CLR, and understand the requirements for building CLR database objects.
Data Access from CLR Database Objects
Learn how to use a CLR routine to access data stored in an instance of SQL Server.
Administering Database Objects with Common Language Runtime (CLR) Integration
See how to manage and secure CLR objects in the database.
Usage Scenarios and Examples for Common Language Runtime (CLR) Integration
A guide to the sample applications, package samples, and numerous coding samples that you can use to learn about the programmability features of common language runtime (CLR) integration.
Database Engine Developer InfoCenter