MaxBeauchemin
1/3/2018 - 2:43 PM

SQL Merge

Merge in SQL allows you to easily Synchronize a target table from a source table

merge
content_copyfile_download
MERGE Target AS T

USING Source AS S

ON (T.EmployeeID = S.EmployeeID) 

WHEN NOT MATCHED BY TARGET

  THEN INSERT(EmployeeID, EmployeeName)
    VALUES (S.EmployeeID, S.EmployeeName)

WHEN MATCHED 

  THEN UPDATE
    SET T.EmployeeName = S.EmployeeName

WHEN NOT MATCHED BY SOURCE

  THEN DELETE 

OUTPUT $action, inserted.*, deleted.*;