| |
Temporary Table |
Table Variable |
| 1. |
Temporary tables are stored in the tempDB database. |
Table variables are stored in memory. |
| 2. |
Temporary table is used for large data sets. |
Table variable is used for small data sets. |
| 3. |
Stored procedures are recompiled every time if it uses a temporary table. |
Stored procedures do not need recompilation every time. |
| 4. |
Temporary tables are slower in performance compare than table variable. |
Table variables are fast as they need fewer resources. |
| 5. |
You do not need to pass temporary table to stored procedures and functions. |
You cannot pass table variable as input or output parameter to stored procedure and functions. |
SQL Server Interview Questions Series - Part 1
