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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2006-05-16 : 05:18:19
|
| when i create a temp table like #table1it is stored as much as i understand under the tempdb (if not please correct me. , and what happend if i deleted the tempdb where then the temptables are being stored??)when the Store Procedure end's - does the temp table deleted it self or should i do it (and how?)thnaks in advancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-05-16 : 05:37:42
|
| The temp table would be removed when it goes out of scope, you don't need to drop it yourself.-------Moo. :) |
 |
|
|
|
|
|
temp table in Stored procedures and deleteing the