Archive for September, 2008

Difference between Temp Table & Table Variable

Posted on September 2, 2008. Filed under: SQL | Tags: Functions, SQL, SQL Server, Stored procedures, table variable, Temp Table, Temporary table |

Table Variable vs. Temp Table Summary:

Feature

Table Variable

Temp Table

Note

Table Name

Max 128 characters

Max 116 characters

Data Storage

In memory and TempDB

TempDB

Meta Data

In memory

TempDB

A table variable inherits current database settings and can use the registered UDTs, user defined data types, and xml collections in the database. A temp table inherits the settings [...]