Skip to main content

Professional SQL ServerTM 2005 XML

Professional SQL ServerTM 2005 XML

Scott Klein

ISBN: 978-0-471-79307-6

Apr 2006

600 pages

Select type: E-Book

Product not available for purchase

Description

  • 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
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.

Downloadable Code Download