TEMP Table, TEMPORARY Table, Local TEMP Table, Global TEMP Table, TEMP Table vs CTE vs DT

TEMP Table, TEMPORARY Table, Local TEMP Table, Global TEMP Table, TEMP Table vs CTE vs DT Agenda: Q01. What is Temp Table or Temporary Table in SQL A. Is duplicate Temp Table names allowed B. Can a Temp Table be used for SELECT INTO or INSERT EXEC statement C. What are the different ways to create Temp Table in SQL Q02. What is Local Temporary Table in SQL Q03. What is Global Temporary Table in SQL Q04. What is the difference between Local and Global Temporary Table in SQL Q05. What is the difference between Temp Table and Derived Table in SQL Q06. What is the difference between Temp Table and Common Table Expression in SQL Q07. What is the difference between Temp Table and Table Variable in SQL Q08. What is the difference between Temp Table and TableValued Parameter in SQL Q09. What is the storage location for the Temp Tables Q10. How many Temp Tables can be created with the same name Q11. How many users or who can acce