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 - 2002-02-24 : 21:45:18
|
| Janel writes "Is there any way I can use Query Analyzer to view data in a temporary table?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-24 : 21:59:42
|
| Only if the temporary table is created in the same session you're using in query analyzer (doesn't have to be the same batch of commands necessarily). If you created the temp table using some method, then opened query analyzer under another session (even with the same login), then it will not work. You could use global temp tables (## prefix instead of #) if you need to access it from multiple sessions. |
 |
|
|
|
|
|
View Data in Temporary Tables