What's the difference between a temp table and table variable in SQL Server?

491 votes

2 answers

262167 views

sql-server t-sql temporary-tables table-variable

                          This seems to be an area with quite a few myths and conflicting views.

So what is the difference between a table variable and a local temporary table in SQL Server?

Asked by Martin Smith (88061 rep)

Apr 11, 2012, 10:22 PM
Last activity: May 22, 2023, 09:23 PM

What's the difference between a temp table and table variable in SQL Server?

Related Questions