Versions Compared

Old Version 54

changes.mady.by.user Eugene Koifman

Saved on

compared with

New Version 55

changes.mady.by.user Eugene Koifman

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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>

...