3 out of 4 rated this helpful - Rate this topic

Partially Supported Transact-SQL Statements (Windows Azure SQL Database)

In Microsoft Windows Azure SQL Database, some Transact-SQL statements do not support some of the arguments and options that exist in their corresponding Transact-SQL statements in SQL Server 2008. The following table provides a list of such Transact-SQL statements.

ALTER AUTHORIZATION (Windows Azure SQL Database)	CREATE PROCEDURE (Windows Azure SQL Database)	DROP TRIGGER (Windows Azure SQL Database)
ALTER DATABASE (Windows Azure SQL Database)	CREATE SPATIAL INDEX (Windows Azure SQL Database)	DISABLE TRIGGER (Windows Azure SQL Database)
ALTER FUNCTION (Windows Azure SQL Database)	CREATE SYNONYM (Windows Azure SQL Database)	ENABLE TRIGGER (Windows Azure SQL Database)
ALTER INDEX (Windows Azure SQL Database)	CREATE TABLE (Windows Azure SQL Database)	EXECUTE (Windows Azure SQL Database)
ALTER LOGIN (Windows Azure SQL Database)	CREATE TRIGGER (Windows Azure SQL Database)	EXECUTE AS (Windows Azure SQL Database)
ALTER PROCEDURE (Windows Azure SQL Database)	CREATE TYPE (Windows Azure SQL Database)	EXECUTE AS Clause (Windows Azure SQL Database)
ALTER TABLE (Windows Azure SQL Database)	CREATE USER (Windows Azure SQL Database)	GRANT Database Permissions (Windows Azure SQL Database)
ALTER TRIGGER (Windows Azure SQL Database)	CREATE VIEW (Windows Azure SQL Database)	GRANT Database Principal Permissions (Windows Azure SQL Database)
ALTER USER (Windows Azure SQL Database)	DENY Database Permissions (Windows Azure SQL Database)	GRANT Type Permissions (Windows Azure SQL Database)
ALTER VIEW (Windows Azure SQL Database)	DENY Database Principal Permissions (Windows Azure SQL Database)	INSERT (Windows Azure SQL Database)
CREATE DATABASE (Windows Azure SQL Database)	DENY Type Permissions (Windows Azure SQL Database)	KILL (Windows Azure SQL Database)
CREATE FUNCTION (Windows Azure SQL Database)	DROP DATABASE (Windows Azure SQL Database)	REVOKE Database Permissions (Windows Azure SQL Database)
CREATE INDEX (Windows Azure SQL Database)	DROP INDEX (Windows Azure SQL Database)	REVOKE Database Principal Permissions (Windows Azure SQL Database)
CREATE LOGIN (Windows Azure SQL Database)	DROP TABLE (Windows Azure SQL Database)	REVOKE Type Permissions (Windows Azure SQL Database)
		USE (Windows Azure SQL Database) Note- In Microsoft Windows Azure SQL Database the USE statement does not switch between databases. To change databases, you must directly connect to the database.

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

Community Additions

ADD

Partially Supported Transact-SQL Statements (Windows Azure SQL Database)

See Also

Concepts

Community Additions