Common SQL incompatibilities and resolutions

This section will provide technical details regarding common SQL incompatibilities and resolutions between legacy data warehouse systems and Azure Synapse Analytics. The section will explain and compare the differences and provide resolutions using a quick-reference table that you can refer to later on as you embark on your migration project.

The topics that we will cover are as follows:

• SQL Data Definition Language (DDL) differences and resolutions
• SQL Data Manipulation Language (DML) differences and resolutions
• SQL Data Control Language (DCL) differences and resolutions
• Extended SQL differences and workarounds

SQL DDL differences and resolutions

In this section, we will discuss the differences and resolutions for SQL DDL between legacy data warehouse systems and Azure Synapse Analytics.

Table 18.6: SQL DDL differences between legacy systems and Azure Synapse

SQL DML differences...