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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Temporary Tables

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-08-24 : 13:17:54
Craig Han writes "Dear SQLTeam,

I am currently writing a little VB application which attempts to use global temporary tables on the Microsft SQL Server 7.0.

The temporary table is called ##TempData and I perform 2 inserts one after the other. However, the table disappears before I can perform a select statement on it.

It really has me stumped. Do you have any idea what the problem is?

Thanks."
   

- Advertisement -