Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Eagle_f90
Constraint Violating Yak Guru
424 Posts |
Posted - 2012-10-03 : 19:58:41
|
In 2008R2 if I create #Temp in a query or proc when does that table drop it's self or do I need to remember to call the drop command at the end of my work?-- If I get used to envying others...Those things about my self I pride will slowly fade away.-Stellvia |
|
sql-programmers
Posting Yak Master
190 Posts |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2012-10-04 : 00:48:59
|
for # table, it is created inside a stored procedure, it is destroyed when the stored procedure terminates even if the connection / session is still alive. KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|