http://www.sqlservercentral.com/blogs/dugi/2010/05/14/sql-azure-and-t-sql/ Printed 2014/08/27 03:20PM
SQL Azure and T-SQL
SQL Server Azure database supports the T-SQL, but no at all! For the SQL Server Azure and T-SQL are available three list (Supported, Partially Supported & Unsupported - statements):
Supported T-SQL statements.
- ALTER (SCHEMA, VIEW, ROLE)
- CAST & CONVERT
- DROP (SCHEMA, ROLE, LOGIN, USER, VIEW, STATISTICS, etc)
- ORDER BY
- SET (DATEFIRST, DATEFORMAT etc...)
Check for the full list here.
Partially supported T-SQL statements.
- ALTER (DATABASE, FUNCTION, INDEX, PROCEDURE, etc)
- CREATE (TABLE, INDEX, TRIGGER etc)
- GRANT (Database Persmissions, Database Principal Permissions etc)
- DROP (DATABASE, INDEX, TABLE, TRIGGER, etc)
Check for the full list and further details here.
Unsupported T-SQL statements.
- BACKUP & RESTORE
- BULK INSERT
- DBCC (HELP, CHECKDB, CHECKTABLE, SHRINKFILE etc)
Check for the full list and other details here.
Let's take a look with an example:
~You cannot use:
SELECT * INTO NewTableName
to create direct new table with T-SQL statement.
In this case you should create the NewTableName with the same structure as source table:
CREATE TABLE NewTableName
... same structure as source_table
INSERT INTO NewTableName (Fields...)
* Check for more samples.