1 Introduction

  • Article

SQL Server Transact-SQL ISO/IEC 9075-14 Standards Support Document describes the level of support that is provided by Transact-SQL in both Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 for Part 14: XML-Related Specifications (SQL/XML) of both the 2008 and 2011 versions of the SQL language ISO/IEC 9075 international standard specification and for the XML standards on which the international standard is based.

The Transact-SQL language is a procedural extension of the SQL database programming language as implemented by Microsoft [MSDN-Transact-SQLRef]. Transact-SQL supports and extends ANSI SQL. The Transact-SQL dialect is based on International Standard ISO/IEC 9075.

Unless otherwise stated, the specification excerpts are quoted from ISO/IEC 9075-14:2011. Differences between the ISO/IEC 9075-14:2008 and ISO/IEC 9075-14:2011 excerpts are called out where they occur, unless the difference is minor, such as in subclause renumbering.