Temporary Tables in SQL

Have a look at below link.

http://decipherinfosys.wordpress.com/2007/05/04/temporary-tables-ms-sql-server/

There are two types of temporary tables in TSQL

1.Local temporary tables are temporary tables that are available only to the session that created them. These tables are automatically destroyed at the termination of the procedure or session that created them.
2. Global temporary tables are temporary tables that are available to all sessions and all users. They are dropped automatically when the last session using the temporary table has completed. Both local temporary tables and global temporary tables are physical tables created within the tempdb database.


For more Reffer:http://www.sqlservercentral.com/articles/T-SQL/temptablesinsqlserver/1279/

There are two type of temporary table in sql server.
Local Temporary Table.
and Global Temporary Table.

You can declare local table variable as


Declare @tempTbl Table(id int, name varchar(100))

declare #tbl table(a int)

&
Global table variable as

declare ##tbl table(a int)

http://www.sqlteam.com/article/temporary-tables[^]

code project link
Quick Overview: Temporary Tables in SQL Server 2005[^]