Windows Azure SQL Database Quick Reference - Pro SQL Database for Windows Azure - page 270

Appendix B

Windows Azure SQL Database
Quick Reference

SQL Azure supports T-SQL. Chances are that you're already familiar with SQL Server T-SQL syntax if you're reading
this topic. However, not everything you know and love about SQL Server is supported yet in Windows Azure SQL
Database. For example, many of the T-SQL statements are hardware-related or OS/server-related, such as creating
certificates or creating backup devices. This appendix provides a quick reference to the syntax that is currently
supported in Windows Azure SQL Database as of Service Update 4.

■ You can find a complete list and reference that describes T-SQL features supported in Windows Azure SQL
Database at http://msdn.microsoft.com/en-us/library/ee336281.aspx .

Note

Supported T-SQL Statements
Table B-1 lists the supported T-SQL statements that you can use in Windows Azure SQL Database. These statements
can be used as exactly as you currently know them without any limitations.

Table B-1. Fully Supported T-SQL Statements

ALTER ROLE DENY Object Permissions ORDER BY Clause

ALTER SCHEMA DENY Schema Permissions OUTPUT Clause

ALTER VIEW DROP LOGIN OVER Clause

APPLOCK_MODE DROP PROCEDURE PRINT

APPLOCK_TEST DROP ROLE RAISERROR

BEGIN_TRANSACTION DROP SCHEMA RETURN

BEGIN...END DROP STATISTICS REVERT

BINARY_CHECKSUM DROP SYNONYM REVOKE Object Permissions

BREAK DROP TYPE REVOKE Schema Permissions

CAST and CONVERT DROP USER ROLLBACK TRANSACTION

( continued )