Chapter 9. Working with the SQLCLR

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 ...

Get Programming Microsoft® ADO.NET 2.0 Applications: Advanced Topics now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.