Merge Query In SQL Server
Jul 16, 2021
We need to perform INSERT, UPDATE, and DELETE operations on a target table by matching with records from the source table. For example, a Stock table has information about the stocks and you need to sync this table with the latest information about the stocks from the source table. We would need to write separate DML commands (INSERT statements, UPDATE statements and DELETE statements) to refresh the target table with an updated stock list in your SQL database. In this tip, we will walk through how to use the MERGE statement.
