Professional Sql Server 2005 Clr Programming

Download or read book Professional Sql Server 2005 Clr Programming written by Derek Comingore and published by John Wiley & Sons. This book was released on 2006-12-12 with total page 436 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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.