Pro SQL Server 2008 XML : [the essential guide to managing and programming with XML in a SQL server environment

Front Matter....Pages i-xxviii Enter XML....Pages 1-16 FOR XML and Legacy XML Support....Pages 17-59 The xml Data Type....Pages 61-81 XML Schema Collections....Pages 83-114 XQuery....Pages 115-151 XQuery Functions and Operators and XML DML....Pages 153-176 Indexing XML....Pages 177-192 XSLT and the SQLCLR....Pages 193-229 HTTP SOAP Endpoints....Pages 231-244 .NET XML Support....Pages 245-274 Spatial Data and GML....Pages 275-293 SQLXML....Pages 295-317 LINQ to XML....Pages 319-339 XML Support Tools....Pages 341-355 Back Matter....Pages 357-466 Knowledge and ability to apply XML are de rigueur in today’s world, and SQL Server developers and administrators are no exception to that rule. __Pro SQL Server 2008 XML__ is your key to unlocking the powerful XML feature set first introduced in SQL Server 2005 and since refined in SQL Server 2008. Author **Michael Coles** shows how to store XML using SQL Server’s built–in XML data type. Learn to query and manipulate XML data using standard technologies such as XQuery and XSLT. No SQL Server database professional can afford to be without knowledge of the XML feature set. __Pro SQL Server 2008 XML__ delivers on the knowledge that you need to remain competitive in your career. * Shows how to store, query, and manipulate XML documents in SQL Server * Provides step–by–step examples showing best practices and advanced features * Accurately discusses how SQL Server’s XML feature set stacks up against the ISO XML standards ## What you’ll learn * Store XML documents using SQL Server’s built–in XML data type. * Query those stored documents using SQL/XML and XQuery. * Manipulate and transform XML using XSLT and XPath. * Understand how SQL Server’s XML support compares to the ISO XML standards. * Create SOAP endpoints for use in web services applications. * Create primary and secondary XML indexes to improve performance of XML queries. ## Who is this book for? SQL Server SQL/T–SQL developers and .NET developers who want to take advantage of the specific server–side XML functionality available in SQL Server 2008 ## About the Apress Pro Series The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder. You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hard–won solutions to problems you will face in your professional programming career.

Knowledge and ability to apply XML are de rigueur in today’s world, and SQL Server developers and administrators are no exception to that rule. Pro SQL Server 2008 XML is your key to unlocking the powerful XML feature set first introduced in SQL Server 2005 and since refined in SQL Server 2008. Author Michael Coles shows how to store XML using SQL Server’s built–in XML data type. Learn to query and manipulate XML data using standard technologies such as XQuery and XSLT. No SQL Server database professional can afford to be without knowledge of the XML feature set. Pro SQL Server 2008 XML delivers on the knowledge that you need to remain competitive in your career.

• Shows how to store, query, and manipulate XML documents in SQL Server
• Provides step–by–step examples showing best practices and advanced features
• Accurately discusses how SQL Server’s XML feature set stacks up against the ISO XML standards

What you’ll learn

• Store XML documents using SQL Server’s built–in XML data type
• Query those stored documents using SQL/XML and XQuery
• Manipulate and transform XML using XSLT and XPath
• Understand how SQL Server’s XML support compares to the ISO XML standards
• Create SOAP endpoints for use in web services applications
• Create primary and secondary XML indexes to improve performance of XML queries

Who this book is for

SQL Server SQL/T–SQL developers and .NET developers who want to take advantage of the specific server–side XML functionality available in SQL Server 2008.