SQL

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. [...]