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.

 


Programming Microsoft ADO. NET 2.0 Applications. Advanced Topics
Linux Application Development (2nd Edition)
ISBN: 735621411
EAN: 2147483647
Year: 2004
Pages: 85
Authors: Michael K. Johnson, Erik W. Troan
BUY ON AMAZON

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net