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 ]