SQL SERVER – Difference between Temp table,Table variable and CTE

Source: SQL SERVER – Difference between Temptable,Table variable and CTE

CTE

CTE does not store data in tempdb rather it uses memory to store data.