sql mssql merge

sql-mssql-Merge.sql

--==> https://msdn.microsoft.com/ru-ru/library/bb510625.aspx

MERGE Production.UnitMeasure AS target  
USING (SELECT @UnitMeasureCode, @Name) AS source (UnitMeasureCode, Name)  
ON (target.UnitMeasureCode = source.UnitMeasureCode)  
WHEN MATCHED THEN   
    UPDATE SET Name = source.Name  
WHEN NOT MATCHED THEN  
INSERT (UnitMeasureCode, Name)  
VALUES (source.UnitMeasureCode, source.Name)  
OUTPUT deleted.*, $action, inserted.* INTO #MyTempTable;