Versions Compared

Old Version 63

changes.mady.by.user Shannon Ladymon

Saved on

compared with

New Version 64

changes.mady.by.user Eugene Koifman

Saved on

Key

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

...

  • 1, 2, or 3 WHEN clauses may be present; at most 1 of each type:  UPDATE/DELETE/INSERT.
  • WHEN NOT MATCHED must be the last WHEN clause.
  • If both UPDATE and DELETE clauses are present, the first one in the statement must include [AND <boolean expression>].
  • Vectorization will be turned off for merge operations.  This is automatic and requires no action on the part of the user.  Non-delete operations are not affected.  Tables with deleted data can still be queried using vectorization.
Examples