title: How to populate temp table structure fast from source table in sp?
body: <p>I want to create a temp table structure from a physical table in sp.</p>
  
  <p>I have two approaches</p>
  
  <pre><code>Select * into #temptable from MainTable where NULL=NULL
  </code></pre>
  
  <p>or </p>
  
  <pre><code>Select * into #temptable from MainTable where 1=0
  </code></pre>
  
  <p>I have many statement in sp that creates temp table structures, so it is necessary to opt a better approach for temp table creation.</p>
  
  <p>Please let me know the better way to create a temp table with high performance.</p>