View Larger Image	Scott Klein Wrox Press, Paperback, Published December 2005, 600 pages, ISBN 0764597922
	List Price: $49.99 Our Price: $30.50 You Save: $19.49 (39% Off)
	Availability: Out-Of-Stock

Read an Article: SQL Server 2005 Programmability Enhancements — Common Table Expressions by Scott Klein       Excerpt provided courtesy of John Wiley & Sons Inc. Copyright © John Wiley & Sons Inc. Written permission from the publisher is required for any use of this material.

People who purchase this book frequently purchase:

• Professional SQL Server 2005 Integration Services; Brian Knight, et al, $30.95, 38% Off!
• Professional SQL Server 2005 Reporting Services; Paul Turley, et al, $24.95, 38% Off!
• Professional ASP.NET 2.0 XML; Thiru Thangarathinam, $24.95, 38% Off!
• Inside Microsoft SQL Server 2005: T-SQL Querying; Itzik Ben-Gan, $28.50, 37% Off!

• Databases : Microsoft SQL Server
• Databases : SQL
• Databases : SQL Server 2005
• * Series - Int/Adv Users : Wrox Professional

• Wrox Press

• Discusses SQL Server 2005 XML from the server and client sides
• Examines using XSLT to render the XML data that is retrieved from SQL Server, particularly for ASP.NET
• Addresses SQL Server relationship with schemas, SOAP, XML security, and .NET
• Makes extensive use of examples to solve problems that programmers face on an everyday basis and features Server 2005 XML best practices

Table of Contents

Introduction.

Part I: Introduction to SQL Server 2005 XML.

Chapter 1: What’s New in Version 2.0 of the .NET Framework for XML.

Chapter 2: What’s New in SQL Server 2005 XML.

Chapter 3: Installing SQL Server 2005.

Part II: Server-Side XML Processing in SQL Server 2005.

Chapter 4: xml data type.

Chapter 5: Querying and Modifying XML Data in SQL Server 2005.

Chapter 6: Indexing XML Data in SQL Server 2005.

Chapter 7: XML Schemas in SQL Server 2005.

Chapter 8: Transact-SQL Enhancements to FOR XML and OPENXML.

Chapter 9: CLR Support in SQL Server 2005.

Part III: Client-Side XML Processing in SQL Server 2005.

Chapter 10: Client-Side Support for the xml data type.

Chapter 11: Client-Side XML Processing with SQLXML 4.0.

Chapter 12: Creating and Querying XML Views.

Chapter 13: Updating the XML View Using Updategrams.

Chapter 14: Bulk Loading XML Data Through the XML View.

Chapter 15: SQLXML Data Access Methods.

Chapter 16: Using XSLT in SQL Server 2005.

Part IV: SQL Server 2005, SqlXml, and SOAP.

Chapter 17: Web Service (SOAP) Support in SQL Server 2005.

Chapter 18: SOAP at the Client.

Chapter 19: Web Service Description Language (WSDL).

Part V: SQL Server 2005 and Visual Studio 2005.

Chapter 20: SQL Server 2005 SQLXML Managed Classes.

Chapter 21: Working with Assemblies.

Chapter 22: Creating .NET Routines.

Chapter 23: ADO.NET.

Chapter 24: ADO.NET 2.0 Guidelines and Best Practices.

Chapter 25: Case Study — Putting It All Together.

Appendix A: XQuery in SQL Server 2005.

Index.

About the Author

Scott Klein is a software developer and architect, and his passion for SQL Server, .NET, and all things XML led him to Greenville, South Carolina, where he currently works as a SQL/.NET developer for CSI, a software solutions company. He has written several articles for TopXML (www.TopXLM.com) and is a frequent speaker at SQL Server and .NET user groups around Greenville and the surrounding areas. When he is not sitting in front of a computer or spending time with his family, he can usually be found aboard his Yamaha at the local motocross track.

Forgot your password? FAQs Shipping Options Returns Your Orders Your Account