PROFESSIONAL SQL SERVER 2005 CLR PROGRAMMING

0.0

This book is targeted to software developers who want to develop stored procedures without having to deal with the eccentricities of TSQL. The authors begin by contrasting the new capabilities available with managed stored procedures (MSPs) against traditional T-SQL. They then move to the tutorial, showing how to build stored procedures using both C# and VB in the .NET environment. Topics include: · Create, update, and delete managed stored procedures.· Convert existing T-SQL to MSPs· Integrate MSPs within new and existing database applications· Error handling· Administration and securityThe authors conclude the book with a detailed case example showing how a problem set can now be solved with SQL Server 2005, contrasting this solution with older T-SQL based methods. The companion website will provide several fully working routines that readers can implement in their own applications. Table of contents : AcknowledgmentsIntroduction· Introducing SQL CLR· Your First CLR Stored Procedure· SQL CLR Structure and Common Tasks· Creating SQL CLR Objects· Comparing T-SQL with Managed Code· Replacing Extended Stored Procedures, Functions, and Other T-SQL Objects· The .NET Framework's Base Class Library· Using SQL CLR Stored Procedures in Your Applications· Handling Errors in CLR Stored Procedures· CLR Administration and Security· Case StudyIndex Market Description : · Professional SQL Server developers About Author : Derek Comingore has worked in a variety of industries, providing technology solutions based on the Microsoft platform. He holds the MCP/MCDBA/MCAD MS certifications. He is a contributor to MSDN, and has recently started a new SQL Server community, www.sqlserver360.com.Douglas Hinson has worked as an independent software and database consultant in the logistics and financial industries, with an extensive SQL Server background. He has co-authored several Wrox boos including Professional SQL Server 2005 Integration Services.