Which Transact-SQL Statements are Supported on Microsoft Azure SQL Database?

March 18, 2014 — 1 Comment

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.

Trackbacks and Pingbacks:

  1. Dew Drop – March 19, 2014 (#1746) | Morning Dew - March 19, 2014

    […] Which Transact-SQL Statements are Supported on Windows Azure SQL Database? (Alexandre Brisebois) […]

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s