Professional Sql Server 2005 Clr Programming - With Stored Procedures, Functions, Triggers, Aggregates and Types

SQL Server 2005 offers the capability to write code in a .NET language that can be compiled and run inside SQL Server. CLR Integration, or SQL CLR, lets you create stored procedures and aggregates using a .NET managed language. This book helps you decide whether to use SQL CLR, how to lock down security, and learn from real examples.

List of contents

Acknowledgments.
Introduction.
Chapter 1: Introducing SQL CLR.
Chapter 2: Your First CLR Stored Procedure.
Chapter 3: SQL CLR Structure and Common Tasks.
Chapter 4: Creating SQL CLR Objects.
Chapter 5: Comparing T-SQLwith Managed Code.
Chapter 6: Replacing Extended Stored Procedures, Functions, and Other T-SQL Objects.
Chapter 7: The .NET Framework's Base Class Library.
Chapter 8: Using SQL CLR Stored Procedures in Your Applications.
Chapter 9: Handling Errors in CLR Stored Procedures.
Chapter 10: CLR Administration and Security.
Chapter 11: Case Study.
Index.

Product details

• Authors: Derek Comingore, Derek Hinson Comingore, Douglas Hinson
• Publisher: Wiley, John and Sons Ltd
• Languages: English
• Product format: Paperback / Softback
• Released: 08.12.2006
• EAN: 9780470054031
• ISBN: 978-0-470-05403-1
• No. of pages: 432
• Subject: Natural sciences, medicine, IT, technology > IT, data processing > Application software