LOCAL AND GLOBAL TEMP TABLE

LOCAL TEMP TABLE

Local temp table visible if there is a connection , and deleted when connection is closed.

 CREATE TABLE #<tablename>

GLOBAL TEMP TABLE

Global temp table is visible to all user,and are deleted when the connection that created it is closed.

 CREATE TABLE ##<tablename>