Get list of columns in a temp table in SQL Server
<p>I am creating a temporary table on-the-fly using <code>Select * Into #temp from SomeChangingSource</code> in a stored procedure. I need to then list the resulting columns.</p>

<p>Handling this for a regular (permanent) table is as simple as:</p>

<pre><code>select COLUMN_NAME 
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='TableName'
</code></pre>

<p>How do I handle this for a temporary table?</p>