Reputation: 9923
SQL Azure seems pretty cool. Some things are not available in SQL Azure though. For example, you can't do switch database with a USE statement - which is pretty understandable.
What other features are missing in SQL Azure?
Upvotes: 2
Views: 1745
Reputation: 300759
SQL Server Feature Limitations (SQL Azure Database)
Guidelines and Limitations (SQL Azure Database)
Upvotes: 2
Reputation: 28701
Here's a decent round-up of a feature comparison between SQL Azure and SQL Server. It's a big list of items - probably too big to enumerate here.
http://social.technet.microsoft.com/wiki/contents/articles/compare-sql-server-with-sql-azure.aspx
Here's a list of partially supported T-SQL statements. Here's a list of unsupported T-SQL statements.
Upvotes: 3