title: Insert values from a different table with a new column with constant value in T-SQL
body: <p>I am inserting all values from a table into another table, which is created on the fly. I want to insert one extra column with constant value to the new table I create.  </p>
  
  <p>I have my <code>FinSls</code> table like this,</p>
  
  <pre><code>Time             Terminal_ID   Count
  ------------------------------------
  2017-10-19 06:03:00     1       5
  2017-10-19 06:04:00     1       2
  2017-10-19 06:05:00     1       2
  2017-10-19 06:06:00     1       2
  2017-10-19 06:03:00     9       2
  2017-10-19 06:04:00     9       3
  2017-10-19 06:05:00     9       2
  2017-10-19 06:06:00     9       3
  </code></pre>
  
  <p>I am creating a new table <code>BinTable</code> and I want to add a column <code>cons_val</code>  with a constant value, for example: 1, like this,</p>
  
  <pre><code>Time              Terminal_ID  Count  Cons_value
  ------------------------------------------------
  2017-10-19 06:03:00     1       5      1
  2017-10-19 06:04:00     1       2      1
  2017-10-19 06:05:00     1       2      1
  2017-10-19 06:06:00     1       2      1
  2017-10-19 06:03:00     9       2      1
  2017-10-19 06:04:00     9       3      1
  2017-10-19 06:05:00     9       2      1
  2017-10-19 06:06:00     9       3      1
  </code></pre>
  
  <p>So far I have my script like this,</p>
  
  <pre><code>select *
  into  
     BinTable
  from 
     FinlSls
  </code></pre>
  
  <p>How can I add a new column <code>Cons_Value</code> into my <code>BinTable</code>? I saw this <a href="https://stackoverflow.com/questions/13089513/is-it-possible-to-copy-all-data-from-one-table-to-another-table-plus-an-extra-c">post</a> that already has the table created and then inserting value. But in my situation, how can I do this?</p>
  
  <p>Any help would be awesome. </p>