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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-16 : 15:09:03
|
Alpha writes "I have a need to identify the local temporary table, with a single #-sign, so that I can 'drop' it before being re-'create' it. I know that this table will be auto-'drop' on completion of the query session but what I need is to avoid getting error of not finding the temporary table to begin with.
On tempdb..sysobjects I can see that this temp table has a string of numbers as its suffix. Can I retrieve this string of numbers ?
Thanks" |
|
|
|
|
|
tempdb