Azure SQL Devs’ Corner

Voices from the Azure SQL PM Team, focusing on development and developers

CTEs, Views or Temp Tables?

I've just finished watching the video from the @GuyInACube about Common Table Expressions and I noticed that in several comments there was the request to explain what is the difference between Common Table Expressions, Views and Temp Tables. This is quite a common question, and it is time to give it a simple, concise, and clear answer...