SALES: 1-800-867-1380

Supported Transact-SQL Statements (Azure SQL Database)

Updated: February 21, 2014

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

The following table provides a list of Transact-SQL statements that are supported by Microsoft Microsoft Azure SQL Database . These Transact-SQL statements provide the same functionality as their corresponding Transact-SQL statements in SQL Server 2008.  

ImportantImportant
For more information about Transact-SQL grammar, usage, and examples, see Transact-SQL Reference (Database Engine) in SQL Server Books Online.

 

ALTER ROLE

DECLARE CURSOR

OPEN

ALTER SCHEMA

DELETE

OPTION Clause

ALTER VIEW

DENY Object Permissions

ORDER BY Clause

APPLOCK_MODE

DENY Schema Permissions

OUTPUT Clause

APPLOCK_TEST

DROP LOGIN

OVER Clause

BEGIN_TRANSACTION

DROP PROCEDURE

PRINT

BEGIN…END

DROP ROLE

RAISERROR

BINARY_CHECKSUM

DROP SCHEMA

RETURN

BREAK

DROP STATISTICS

REVERT

CAST and CONVERT

DROP SYNONYM

REVOKE Object Permissions

CATCH (TRY…CATCH)

DROP TYPE

REVOKE Schema Permissions

CEILING

DROP USER

ROLLBACK TRANSACTION

CHECKSUM

DROP VIEW

ROLLBACK WORK

CLOSE

END (BEGIN…END)

SAVE TRANSACTION

COALESCE

EXCEPT and INTERSECT

SELECT @local_variable

FETCH

SELECT Clause

COLUMNPROPERTY

FOR Clause (XML and BROWSE)

SET @local_variable

COMMIT TRANSACTION

FROM

SWITCHOFFSET

COMMIT WORK

GO (Not technically Transact-SQL. For more information, see GO (Transact-SQL).)

THROW

GOTO

TERTIARY_WEIGHTS

CONTEXT_INFO

GRANT Object Permissions

TODATETIMEOFFSET

CONTINUE

GRANT Schema Permissions

TOP

CONVERT

GROUP BY

TRIGGER_NESTLEVEL

CREATE ROLE

GROUPING_ID

TRUNCATE TABLE

CREATE SCHEMA

HashBytes

TRY…CATCH

CREATE STATISTICS

HAVING

UNION

CREATE VIEW

Hints, such as Query Hints, Join Hits, and Table Hints

noteNote
For more information on Hints, see Support for Hints.

UPDATE

CRYPT_GEN_RANDOM

IDENTITY (Property)

UPDATE STATISTICS

CURRENT_REQUEST_ID

IF…ELSE

USER

CURSOR_STATUS

INSERT BULK

SWITCHOFFSET

DBCC SHOW_STATISTICS

IS [NOT] NULL

WAITFOR

DEALLOCATE

MERGE

WHERE

DECLARE @local_variable

MIN_ACTIVE_ROWVERSION

WHILE

WITH common_table_expression

Support for Hints

Hints are options or strategies specified for enforcement by the underlying query processor on SELECT, INSERT, UPDATE, DELETE, or MERGE statements. Microsoft Azure SQL Database supports all the Query, Table, and Join Hints provided by SQL Server with a few exceptions. When running queries, Microsoft Azure SQL Database always sets the max degree of parallelism to 1 automatically and ignores the MAXDOP hint even if it is used. In addition, SQL Database does not support the PAGLOCK table hint.

For more information, see Hints (Transact-SQL) and max degree of parallelism Option.

Support for SET statements

The Transact-SQL programming language provides several SET statements that change the current session handling of specific information.

The following table provides a list of SET statements supported by Microsoft Azure SQL Database. Note that these SET statements provide the same functionality as their corresponding SET statements in SQL Server 2008.

 

SET Statement Category Statement

Date and time statements

SET DATEFIRST

SET DATEFORMAT

Locking statements

SET DEADLOCK_PRIORITY

SET LOCK_TIMEOUT

Miscellaneous statements

SET CURSOR_CLOSE_ON_COMMIT

SET FIPS_FLAGGER

SET IDENTITY_INSERT

SET LANGUAGE

SET QUOTED_IDENTIFIER

Query Execution Statements

SET ARITHABORT

SET ARITHIGNORE

SET NOCOUNT

SET NOEXEC

SET NUMERIC_ROUNDABORT

SET PARSEONLY

SET ROWCOUNT

SET TEXTSIZE

ISO Settings statements

SET ANSI_NULL_DFLT_OFF

SET ANSI_NULL_DFLT_ON

SET ANSI_PADDING_ON

SET ANSI_WARNINGS

Statistics statements

SET FORCEPLAN

SET SHOWPLAN_ALL

SET SHOWPLAN_TEXT

SET SHOWPLAN_XML

SET STATISTICS IO

SET STATISTICS PROFILE

SET STATISTICS TIME

SET STATISTICS XML

Transactions statements

SET IMPLICIT_TRANSACTIONS

SET TRANSACTION ISOLATION LEVEL

SET XACT_ABORT

See Also

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2014 Microsoft