title: Automatically match columns in INSERT INTO ... SELECT ... FROM
body: <p>SQL Server question.
  When doing</p>
  <pre><code>INSERT INTO T1 SELECT (C1, C2) FROM T2
  </code></pre>
  <p>I don't want to specify column names of <code>T1</code> because they are the same as in <code>T2</code></p>
  <p>Is it possible to do so?</p>
  <p>Currently I'm getting error</p>
  <blockquote>
  <p>Msg 213, Level 16, State 1, Line 1</p>
  <p>Column name or number of supplied values does not match table definition.</p>
  </blockquote>