Read more
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
List of contents
Enter XML.- FOR XML and Legacy XML Support.- The xml Data Type.- XML Schema Collections.- XQuery.- XQuery Functions and Operators and XML DML.- Indexing XML.- XSLT and the SQLCLR.- HTTP SOAP Endpoints.- .NET XML Support.- Spatial Data and GML.- SQLXML.- LINQ to XML.- XML Support Tools.
About the author
Michael Coles is a Microsoft MVP (SQL) with over 15 years experience designing and developing mission-critical SQL Server databases and data-driven systems in the real world. A prolific writer of books and articles on all aspects of SQL Server development, he holds multiple Microsoft certifications and a bachelor s of science degree in Information Technology. Most recently Michael authored the Apress books Pro T-SQL 2008 Programmer s Guide and Pro Full-Text Search In SQL Server 2008.
Summary
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
