BEGIN TRAN; 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 DELETE; --OUTPUT $action, Inserted.*, Deleted.*; ROLLBACK TRAN;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)