New features of XML in SQL Server 2008

SQL Server Technical Articles

Author: Graeme Malcolm (Content Supervisor)

Technical review: Dragan Tomic and Michael Rys

Project Editor: Joanne Hodgins

Release Date: August 2008

Applicable products: SQL Server 2008

Summary: Microsoft®sql server™2008 builds broad support for XML by enhancing support for XML schema validation and XQuery and adding XML data types.

Copyright

This is a preliminary document that may vary significantly before the final commercial version of the software described in this document has been released.

The information provided in this document represents the current view of Microsoft Corporation (prior to software release) on the issues under discussion. Because Microsoft must respond to changing market conditions, its current view should not be interpreted as a commitment, and Microsoft cannot guarantee that all information now provided is accurate after the release of the software.

This white paper is for informational purposes only. Microsoft does not make any warranty, express, implied or legal commitment to the information provided in this document.

The user is responsible for complying with all applicable copyright laws. Subject to copyright rights, nothing in this document may be reproduced, stored in or placed in a retrieval system, or converted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise) or for any purpose, without the express written permission of Microsoft company.

Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights in the subject matter covered by this document. Without a clear indication from any written license agreement from Microsoft, this document does not give you any license to these patents, trademarks, copyrights, or other intellectual property.

Unless otherwise noted, the example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious, regardless of any real company, organization, product, domain name, e-mail address, logo, person, place, or event.

ó2007 Microsoft Corporation. All rights reserved.

Microsoft and SQL Server are registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries/regions.

The names of the real companies and products mentioned in this document may be the trademarks of their respective owners.

Directory

Introduction 1

Evolution of SQL Server XML functionality 1

XML functionality in SQL Server 2000 1

XML functionality in SQL Server 2005 2

XML functionality in SQL Server 2008 4

XML Schema Validation Enhancements 4

Lax Authentication Support 5

Full Xs:datetime Support 6

Union and List type 6

XQuery Enhancements 8

XML DML Enhancements 9

Conclusion 10