Professional SQL Server 2005 XML

✍ Scribed by Scott Klein

• Publisher: Wrox/Wiley Pub
• Year: 2006
• Tongue: English
• Leaves: 540
• Series: Wrox professional guides \ Programmer to Programmer
• Category: Library

✦ Synopsis

• 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

Professional SQL Server 2005 XML......Page 1
Table of Contents......Page 7
Introduction......Page 8
Part I: Introduction to SQL Server 2005 XML......Page 14
C1: What's New in Version 2.0 of the .NET Framework of XML......Page 16
System.xml Version 2.0 Enhancements and New Features......Page 17
Performance......Page 18
Type Support......Page 19
XPathDocument......Page 21
XPathNavigator......Page 22
XML Query Architecture......Page 23
XmlReader, XmlReaderSettings, XmlWriter, and XmlWriterSettings......Page 24
Summary......Page 26
C2: What's New in SQL Server XML......Page 28
xml data type......Page 29
C3: Installing SQL Server 2005......Page 48
Part II: Server-Side XML Processing in SQL Server 2005......Page 64
C4: xml data type......Page 66
C5: Querying and Modifying XML Data in SQL Server 2005......Page 98
C6: Indexing XML Data in SQL Server 2005......Page 124
C7: XML Schemas in SQL Server 2005......Page 140
C8: Transact-SQL Enhancements to FOR XML and OPENXML......Page 160
C9: CLR Support in SQL Server 2005......Page 184
Part III: Client-Side XML Processing in SQL Server 2005......Page 198
C10: Client-Side Support for the xml data type......Page 200
C11: Client-Side XML Processing with SQLXML 4.0......Page 212
C12: Creating and Querying XML Views......Page 224
C13: Updating the XML View Using Updategrams......Page 244
C14: Bulk Loading XML Data Through the XML View......Page 270
C15: SQLXML Data Access Methods......Page 286
C16: Using XSLT in SQL Server 2005......Page 308
Part IV: SQL Server 2005, SqlXml, and SOAP......Page 322
C17: Web Service (SOAP) Support in SQL Server 2005......Page 324
C18: SOAP at the Client......Page 350
C19: Web Service Description Language (WSDL)......Page 368
Part V: SQL Server 2005 and Visual Studio 2005......Page 388
C20: SQL Server 2005 SQLXML Managed Classes......Page 390
C21: Working with Assemblies......Page 410
C22: Creating .NET Routines......Page 430
C23: ADO.NET......Page 454
C24: ADO.NET 2.0 Guidelines and Best Practices......Page 468
C25: Case Study -- Putting It All Together......Page 474
Appendix A; XQuery in SQL Server 2005......Page 498
Index......Page 520