Category: Transact-SQL

This category contains useful information relating to Transact SQL (TSQL).

MERGE Transact-SQL statement example

I have only just found out about the “MERGE” transact-SQL statement that was introduced in SQL Server 2008.

From https://docs.microsoft.com/en-us/sql/t-sql/statements/merge-transact-sql:

“Performs insert, update, or delete operations on a target table based on the results of a join with a source table. For example, you can synchronize two tables by inserting, updating, or deleting rows in one table based on differences found in the other table.”

Page 1 of 41234
CJayMead's SQL Server, Endeca, MS Office Help © 2018