Murach's SQL Server 2005 for Developers
An introduction to CLR integration

One of the most-anticipated new features of SQL Server 2005 is its ability to host the .NET Framework’s Common Language Runtime (CLR). This allows developers to use any .NET language to create database objects such as stored procedures, functions, and triggers, as well as new types of database objects that aren't available from T-SQL.
     This chapter introduces you to CLR integration, explaining what it is and showing you how to work with CLR objects.
Chapter 19 An introduction to CLR integration
An introduction to CLR integration 582
How CLR integration works 582
The five types of CLR objects 584
When to use CLR objects 584
How to enable CLR integration 586
How to use Visual Studio to work with CLR objects 588
How to start a SQL Server project 588
How to specify the type of CLR object 592
How to enter and edit the code for CLR objects 594
The code for a CLR object 596
How to compile and deploy CLR objects 598
How to test and debug a CLR object 600
How to use SQL to work with CLR objects 602
How to deploy an assembly 602
How to deploy a CLR object 602
How to drop an assembly 602
Perspective 604
t


© Copyright 1998-2008 Mike Murach & Associates, Inc.  All rights reserved.

Murach's SQL Server 2005

Learn more about this book

View the table of contents

Add this book to your cart



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.