Transact-SQL Reference (SQL Azure Database)

Microsoft SQL Azure Database supports Transact-SQL grammar that you can use to query a database and to insert, update, and delete data in tables in a database. The topics in this section describe the Transact-SQL grammar support provided by SQL Azure.

Important:
The Transact-SQL Reference for SQL Azure is a subset of Transact-SQL for SQL Server.

In this Section

This section provides a series of foundational topics for understanding and using the Transact-SQL grammar with SQL Azure. To view details about data types, functions, operators, statements, and more, you can browse through the table of contents in these sections or search for topics in the index.

Topic	Description
Syntax Conventions (SQL Azure Database)	Describes the conventions that are used in the syntax diagrams in the Transact-SQL statements.
Data Types (SQL Azure Database)	Describes both supported and unsupported system data types in SQL Azure.
Functions (SQL Azure Database)	Describes both supported and unsupported built-in functions in SQL Azure.
Operators (SQL Azure Database)	Describes both supported and unsupported operators in SQL Azure.
System Stored Procedures (SQL Azure Database)	Describes both supported and unsupported system stored procedures in SQL Azure.
System Tables (SQL Azure Database)	Describes the support for the system tables.
System Views (SQL Azure Database)	Describes both supported and unsupported system views in SQL Azure.
Supported Transact-SQL Statements (SQL Azure Database)	Describes a set of Transact-SQL statements that can be used with SQL Azure.
Partially Supported Transact-SQL Statements (SQL Azure Database)	Describes a set of modified Transact-SQL statements that can be used with SQL Azure.
Unsupported Transact-SQL Statements (SQL Azure Database)	Describes the unsupported Transact-SQL statements in SQL Azure.

For more information about Transact-SQL, see Transact-SQL Reference (Database Engine) in SQL Server Books Online.

Concepts

Introducing SQL Azure Database