11.0 Temporary Tables, Table Variables and Recompileshttp://blogs.msdn.com/sqlprogrammability/archive/2007/01/18/11-0-temporary-tables-table-variables-and-recompiles.aspx11.1 Temporary Tables versus Table Variables In order to determine if table variables or temporary tables is the best fit for your application, let us first examine some characteristics of table variables and temporary tables: 1. Table variables haveen-USCommunityServer 2.1 SP1 (Build: 61025.2)re: 11.0 Temporary Tables, Table Variables and Recompileshttp://blogs.msdn.com/sqlprogrammability/archive/2007/01/18/11-0-temporary-tables-table-variables-and-recompiles.aspx#1552717Mon, 29 Jan 2007 23:11:45 GMT91d46819-8472-40ad-a661-2c78acb4018c:1552717BSovers<p>Does anyone know if the limitation of not being able to use a table variable as an input parameter to a stored procedure is going to be resolved in a future version?</p> <p>This would be NICE functionality, and a legitimate extension to the table variable data structure.</p>Never use table variables?http://blogs.msdn.com/sqlprogrammability/archive/2007/01/18/11-0-temporary-tables-table-variables-and-recompiles.aspx#7319288Wed, 30 Jan 2008 07:14:06 GMT91d46819-8472-40ad-a661-2c78acb4018c:7319288Jason Massie's SQL blog<p>MS pushed tables variables too hard back in 2000 and developers went a little crazy with them. However,</p> <h1>Never use table variables?</h1>http://blogs.msdn.com/sqlprogrammability/archive/2007/01/18/11-0-temporary-tables-table-variables-and-recompiles.aspx#7319430Wed, 30 Jan 2008 07:25:09 GMT91d46819-8472-40ad-a661-2c78acb4018c:7319430SELECT IsUseless(blabber) from sys.innarwebs CROSS APPLY jmass(blog)<p>&amp;lt;p&amp;gt;MS pushed tables variables too hard back in 2000 and developers went a little crazy with them. However, we found out that they were not the greatest thing since sliced bread especially when t ...</p>