title: Get list of columns in a temp table in SQL Server
body: <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>