Professional SQL Server 2005 XML

  • 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

Biography

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.

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.

Sign up now to get free exclusive access to reports, research and invitation only events.
Featured Download
/downloads/product/161/softdisc/

SoftDisc

SoftDisc is an image file tool that allows you to create, edit and manage your image files. It also lets you emulate a virtual CD ...

Computerworld newsletter

Join the most dedicated community for IT managers, leaders and professionals in Australia