Question

What are the differences between local and global temporary tables?

Answer 1

What are the differences between local and global temporary tables?

Local temporary tables are visible when there is a connection, and are deleted when the connection is closed.

CREATE TABLE #<tablename>

Global temporary tables are visible to all users, and are deleted when the connection that created it is closed.

CREATE TABLE ##<tablename>