what feature is missing in SQL Azure

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开发者_如何学JAVA missing in SQL Azure?

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.

SQL Server Feature Limitations (SQL Azure Database)

Guidelines and Limitations (SQL Azure Database)