title: Table variable vs temp table in SQL Server 2008
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/27894/whats-the-difference-between-a-temp-table-and-table-variable-in-sql-server">What&#39;s the difference between a temp table and table variable in SQL Server?</a>  </p>
  </blockquote>
  
  
  
  <p>What is the difference between table variable and temp table, actually I have two question on it.</p>
  
  <ul>
  <li>how to decide when to use what?</li>
  <li>which one is better in performance and WHY ?</li>
  </ul>