Maintained with ☕️ by
IcePanel logo

Generally available: MERGE command for Azure Synapse Analytics

Share

Services

The MERGE command for dedicated SQL pools in Azure Synapse Analytics allows you to insert, update or delete data from one table based on differences discovered in another table. With the MERGE command, the previous multi-step process to synchronise two tables in a dedicated SQL pool is now streamlined into a single step, thus easing migrations and improving code readability. [Learn more](https://learn.microsoft.com/en-us/sql/t-sql/statements/merge-transact-sql?view=azure-sqldw-latest&preserve-view=true). * Azure Synapse Analytics * Features * [ Azure Synapse Analytics](https://azure.microsoft.com/en-gb/products/synapse-analytics/)