temp tables, are they gone when I close that session?

[daglugub37]

Is there anyway I can retrieve a temp table(# table) if I closed the session that created it?

Can I query the temporary database for it?

 

[mutley1]

Hi daglubub37,

Check out the first 2 paragraphs of this article.

http://www.programmers-corner.com/article/76

Yes you can query them, but best practice if you're using it in a script is to drop it anyway:

Create table #temp (enter structure)
insert #temp (enter query to populate)
select x from #temp
drop table #temp

HTH,
M.

 

[mrdenny]

Once the session that creates a temp table has closed the temp table is gone. Temp tables are session specific and are only available to the session that created them.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com