Last night I spoke at the Communauté .NET Montréal about Azure SQL Database and Your Data. Throughout the evening many great questions surfaced and helps us gain a better understanding of what the differences were between SQL Server and SQL Database.
One question stood out and it was “what statements are supported on SQL Database?”
Following our discussions I was fortunate to come across the following MSDN pages (Thanks to Mike Martin for pointing these out).
A list of unsupported Transact-SQL Statements for Azure SQL Database
Microsoft Azure SQL Database does not support all of the Transact-SQL statements that are delivered in SQL Server 2008. The following table provides a list of the Transact-SQL statements that Azure SQL Database does not support.
- $PARTITION
- CHECKPOINT
- BULK INSERT
- BACKUP
- MORE…
A list of partially supported Transact-SQL Statements for Azure SQL Database
In Microsoft 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.
A list of supported Transact-SQL Statements for Azure SQL Database
These Transact-SQL statements provide the same functionality as their corresponding Transact-SQL statements in SQL Server 2008.
An additional page also caught my eye and it lays out the Azure SQL Database support for programmability enhancements in SQL Server 2012. Luckily it also points out the programmability enhancements that are not supported at this time.