2019-07-15 11:48:31
| 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. |
