ISBN 9788126510801,PROFESSIONAL SQL SERVER 2005 CLR PROGRAMMING

PROFESSIONAL SQL SERVER 2005 CLR PROGRAMMING

Rs339 Rs399 15% OFF

Availability: Out of Stock

(Free Delivery)

We Accept
ISBN 9788126510801
Check delivery information
 
ISBN 9788126510801
Publisher

Wiley India Pvt Ltd

Publication Year 2007
ISBN-13

ISBN 9788126510801

ISBN-10 8126510803
Binding

Paperback

Number of Pages 432 Pages
Language (English)
Subject

Computer Books

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 security The 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 : Acknowledgments Introduction 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 Study Index 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.

More from Author

Scroll