In our internal discussion forum for SQL Server, somebody asked this question. Here is the answer (Thanks G2) Temporary tables & table variables differ in semantics, capability and query performance. Which one is appropriate for you will depend on
Read More...