ErcanOPAK.com

Creating Local Temp Table [with #]:

SELECT TOP(10) ID INTO #TempTable FROM MyTable

Craeting Global Temp Table [with ##]:

SELECT TOP(10) ID INTO ##TempTable FROM MyTable

Reaching Local Temp Table with Query:

SELECT name FROM tempdb..sysobjects
WHERE name LIKE '#TempTable%'