Pro SQL Server 2005 Assemblies

by Robin Dewson, Julian Skinner

Overview

* First book on the market to show how to effectively exploit the new .NET capabilities of the SQL Server 2005 database.

* Broad audience, with strong appeal to SQL Server developers as well as to VB.NET and C# programmers.

* Provides a detailed and example-driven tutorial on how to build and use .NET assemblies. Shows not only what you can do with assemblies, but what you should, and should not, do.

Product Details

ISBN-13:	9781590595664
Publisher:	Apress
Publication date:	01/04/2006
Series:	Expert's Voice Series
Edition description:	1st ed.
Pages:	296
Product dimensions:	7.01(w) x 9.25(h) x 0.02(d)

About the Author

Robin Dewson has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He has been working with SQL Server since version 6.5 and Visual Basic since version 5. Robin is a consultant mainly in the city of London, where he has been for nearly eight years. He also has been developing a rugby-related website as well as maintaining his own site at Fat-Belly.com.

Table of Contents

• Introducing Assemblies
• Writing a Simple SQL Assembly
• The SQL Server .NET Programming Model
• CLR Stored Procedures
• User-Defined Functions
• User-Defined Types
• User-Defined Aggregates
• CLR Triggers
• Error Handling and Debugging Strategies
• Security
• Integrating Assemblies with Other Technologies