Chapter 9 Working with the SQLCLR

Overview

With the release of Microsoft SQL Server 2005, you can write .NET code that runs within SQL Server. Like Microsoft Internet Information Services (IIS), SQL Server hosts the .NET common language runtime (also known as the SQLCLR or Integrated CLR) and can run .NET code within its server process.

This chapter explores the advantages and disadvantages of running .NET code, which is also known as managed code, within SQL Server. You learn how to create stored procedures, user-defined functions, aggregates, triggers, and user-defined types (UDTs).

Note that Visual Studio 2005 Professional Edition is required to create and use the Database project template that is referenced in this chapter, but this chapter also shows you how to create, deploy, and use SQLCLR features using the command-line compiler.