What is the Difference between Temporary tables and Table Variables?

Temp vs Table Var

My suggestion is go for Table variables when we know that the structure of the table is not going to change in future. Otherwise go for Temporary tables.

Happy Reading :)

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.