Supported Transact-SQL Statements (Windows Azure SQL Database)

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

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

Note
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