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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!