Pro SQL Server 2008 XML

✍ Scribed by Michael Coles (auth.)

• Publisher: Apress
• Year: 2008
• Tongue: English
• Leaves: 478
• Edition: 1
• Category: Library

✦ Synopsis

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

✦ Table of Contents

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

✦ Subjects

Data Structures, Cryptology and Information Theory