Posted In: Common Table Expressions

Temp Table, Table Variable and CTE. When to use what

As a layman or a novice, when we come across the concept of local temporary tables, global temporary tables, table variables or common table expressions; we tend to think that they function similarly i.e. they all store data in them in a tabular format. So whats the difference in them

This Article is TAGGED in #Tables, Common Table Expressions, CTE, Data Object Scope, Global Temporary Tables, SQL Data Objects, Table Variable, Temp table and transactions, Temp Table Scope, Temp tables. Read more