title: How to easily add columns to a temp table?
body: <p>I can add any number and types of columns into a temp table without the need to define them first:</p>
  
  <pre><code>select into #temp from table;
  </code></pre>
  
  <p>But if I want to add columns to this temp table later on in my script, the only way I know how is to:</p>
  
  <pre><code>alter #temp add column int;
  insert into #table (column) select column from table;
  </code></pre>
  
  <p>This is a bit cumbersome if I want to add multiple columns. Is there a way to add column to a temp table without defining them first?</p>