Different types of temporary table in SQl

There are two types of temporary table in SQL. Local and Global.

Local temp tables are similar to Permanent Tables in SQL Server, it accepts the single hash value "#" as the prefix when created. are deleted when the connection is closed.

Global Temporary Tables are also similar to Local Temporary Tables in SQL Server, except two "##" values are used as the prefix at the time of their creation. They are visible to all connections of SQLServer, and only destroyed when the last connection referencing the table is closed