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)
 Dynamicaly building temporary tables

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-09-14 : 14:03:31
Brent writes "I am currently working on a project that I can do in ASP but would be much simpler if I could dynamically create temporary tables.

When I use the Exec command to run a dynamicaly generated SQL statement to create the temporary table, that table is only available until the Exec command finishes executing. Do you know of a way around this?"
   

- Advertisement -