title: Append data into another table with the same columns but different order
body: <p>I am using SQL Server, and I want to write a query to append data from Table 1 into Table 2, which already has some data in it.</p>
  
  <p>This is what I am currently using, but this only works when the columns are exactly the same in the exact same order. My 2 tables have the same columns, but the order is different. There is 200+ columns so I do not want to manually reorder them or have to list them in the query.</p>
  
  <pre><code>INSERT INTO table2
      SELECT * FROM table1
  </code></pre>
  
  <p>This is one way I could do it, but is there a way to append data from table1 into table2 without having to specify each column?</p>
  
  <pre><code>INSERT INTO table2
      SELECT column1, column2 (in the order of table2 columns)
      FROM table1
  </code></pre>