Question: What is the difference between a table variable and a temporary table in MS SQL Server? This question asks about the difference between a table
What is the difference between a table variable and a temporary table in MS SQL Server?
This question asks about the difference between a table variable and a temporary table
Select one answer
Table variables are stored on disk while temporary tables are stored in memory
Table variables can only be used in stored procedures while temporary tables can be used anywhere in the database
Table variables have limited indexing options while temporary tables can be indexed
Table variables are optimized for tast data modification while temporary tables are optimized
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
