...
Code Block |
---|
Standard Syntax: MERGE INTO <target table> AS T USING <source expression/table> AS S ON <boolean expression>expression1> WHEN MATCHED [AND <boolean expression>expression2>] THEN UPDATE SET <set clause list> WHEN MATCHED [AND <boolean expression>expression3>] THEN DELETE WHEN NOT MATCHED [AND <boolean expression>expression4>] THEN INSERT VALUES<value list> |
...