A local temporary table is
created using CREATE TABLE statement with the table name prefixed with single hash sign (#table_name). Local temp tables are only available to the SQL Server session or
connection (means single user) that created the tables. These are automatically
deleted when the session that created the tables has been closed.