title: MERGE INSERT Source.*
body: <p>Currently we have a SQL script to upsert configuration settings.</p>
  
  <pre><code>MERGE [dbo].[ConfigurationSetting] AS Target
  USING (SELECT * FROM (VALUES 
      -- &lt;Snip&gt; Hard-coded rows.
  ) AS s([Id], [Key], [DisplayName], [Value])) AS Source
      ON Target.[Id] = Source.[Id]
  WHEN MATCHED THEN
      UPDATE SET
          [Key] = Source.[Key],
          [DisplayName] = Source.[DisplayName]
          -- Preserve existing [Value]
  WHEN NOT MATCHED BY TARGET THEN 
      INSERT ([Id], [Key], [DisplayName], [Value])
      VALUES (Source.[Id], Source.[Key], Source.[DisplayName], Source.[Value])
  WHEN NOT MATCHED BY SOURCE THEN
      DELETE
  ;
  </code></pre>
  
  <p>This works fine, but just for my desire for simplicity, is there a syntax that can simplify the<br>
  <code>INSERT ... VALUES ...</code> clauses to something resembling <code>INSERT VALUES Source.*</code></p>