How to easily add columns to a temp table?
<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>