Professional SQL Server 2005 XML

by Scott Klein

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

• Format: Paperback
• Language: English
• ISBN: 0764597922
• ISBN13: 9780764597923
• Release Date: January 2006
• Publisher: Wiley Publishing
• Length: 526 Pages
• Weight: 1.90 lbs.
• Dimensions: 1.2" x 7.3" x 9.2"

Customer Reviews

You Need this Book

If you are considering using XML in SQL Server 2005, this book will pay for itself quickly. The clear examples of creating XML Schema collections, altering them, etc. are very helpful. The only problem with this book is that SQL Server 2005 does not fully support XML Schemas. Because this book was written using a beta product (I believe) perhaps the author could not have know exactly how the final version would shake out. However, partial support of standards is important to any developer. You often find out only by trial and error what is supported and what isn't. The Wrox web site offers nothing of the kind for this book. So buy this book, but be aware if you are using complex XML Schemas there may be some surprises (e.g., notation not supported).

excellent book

This was a very good book. It went indepth about xml and how to use it with the new sql server 2005 datatypes. He covers all aspects of xml in sql and how to best use them. Other major new features like using the clr in sql are also covered. I also liked the real world full examples the author provides.

A note from the technical editor TE

SQL Server 2005's XML integration is a much deeper topic than most developers presume at this point, the XML data type is not all there is to "it", I assure you. The book explores all kinds of interesting facets of SQL Server's XML integration including my personal favorite, an appendix that explains XQuery in a comprehensive manner for those traditional TSQL coders. I am beginning the transition myself, from Technical Editor TE to an author via online articles and books, but I will always be available as a TE for Scott! Scott, you rock dude! And I look forward to your next book!