Description of the illustration merge_insert_clause.eps

  
   WHEN NOT MATCHED THEN
    INSERT
    { [ (column [, column ]...) ]
    VALUES ({ expr | DEFAULT }
              [, { expr | DEFAULT } ]...
           ) |
    SET column_value_pairs }
   [ where_clause ]