title: SQL: use SELECT to INSERT data into table with extra column
body: <p>I have a table <code>Table1</code> with 59 columns. <code>Table2</code> is a copy of <code>Table1</code> with one extra column, <code>COLUMN 60</code> at the end. Hence <code>table2</code> has 60 columns. </p>
  
  <p>I am trying to copy the values from <code>table1</code> to <code>table2</code> and set value of the extra column in <code>table2</code> to "value"</p>
  
  <p>Something like this</p>
  
  <pre><code>INSERT INTO Table2
     SELECT * FROM Table1, 'value' AS 'COLUMN 60'
  </code></pre>
  
  <p>How can I do this? Using the code above give me an error:</p>
  
  <blockquote>
    <p><em>An explicit value for the identity column in table 'TableLocation' can only be specified when a column list is used and IDENTITY_INSERT
    is ON.</em></p>
  </blockquote>
  
  <p>I do not want to specify column names because there are too many of those.</p>