O'Reilly logo

Programming Microsoft® ADO.NET 2.0 Applications: Advanced Topics by Glenn Johnson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required