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 Table-Valued 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