title: MERGE without specifying column names in SQL Server 2008
body: <p>I was looking at the <code>MERGE</code> command which seems cool but still it requires the columns to be specified. I'm looking for something like:</p>
  
  <pre><code>MERGE INTO target AS t
  USING source AS s          
  WHEN MATCHED THEN
      UPDATE SET
      [all t.fields = s.fields]
  WHEN NOT MATCHED THEN 
        INSERT ([all fields])
        VALUES ([all s.fields])
  </code></pre>
  
  <p>Is it possible?</p>