1 Introduction

SQL Server Transact-SQL ISO/IEC 9075-2 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 2: Foundation (SQL/Foundation) of both the 2008 and 2011 versions of the SQL language ISO/IEC 9075 international standard specification.

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-2:2011. Differences between the ISO/IEC 9075-2:2008 and ISO/IEC 9075-2:2011 excerpts are called out where they occur, unless the difference is minor, such as in subclause renumbering.