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 |
|
vusil
Starting Member
22 Posts |
 Posted - 2004-05-12 : 06:33:05
|
Hi guys,I realised that when I create a temp table the name gets saved as something like this #Temp_____________________00000001E583. Could someone please explain what this means? If I query tempdb..sysobjects for a particular named temp table that has just been created there are no results.Thank you |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2004-05-12 : 06:53:13
|
| Hi,The temp tables have names like that so that the names can be unique.You see when temp tables are created they are created by a certain process.Imagine if the same process was being run at the same time by different users - you wouldn't want their data to get mixed up now would you?Look at the thread mentioned below, here we test to see if one exists.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=33706Duane. |
 |
|
|
|
|
|
Temporary tables