Professional SQL ServerTM 2005 XML

I bought this book several months ago and was disappointed. One of the problem is that I am consistently debugging the codes. I am at Chapter 5 now and have spent numerous times googling to try to understand what is the correct syntex for some codes, such as using xml method for column-level contraints, which was demonstated in the book, but does not work. The other thing I don't like is the lack of explanation about the code examples. Many times, a code was throw out without clear explantion, such as how cross apply, outer apply works. 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

• 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

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 Discusses SQL Server 2005 XML from the server and client sides and examines using XSLT to render the XML data that is retrieved from SQL Server, particularly for ASP.NET. This book addresses SQL Server relationship with schemas, SOAP, XML security, and .NET, and uses examples to solve problems and features Server 2005 XML best practices.