title: How to retrieve field names from temporary table (SQL Server 2008)
body: <p>I'm using SQL Server 2008. Say I create a temporary table like this one:</p>
  
  <pre><code>create table #MyTempTable (col1 int,col2 varchar(10))
  </code></pre>
  
  <p>How can I retrieve the list of fields dynamically? I would like to see something like this:</p>
  
  <pre><code>Fields:
  col1
  col2
  </code></pre>
  
  <p>I was thinking of querying sys.columns but it doesn't seem to store any info about temporary tables. Any ideas?</p>