There are three types of temporary tables in SQL Server. The local temporary table, the global temporary table and the table variable.
Everyone of them has a use case and advantages and disadvantages.
First things first. Despite popular belief ALL
three types are stored in tempdb. We will prove that so you don't have to ....