Err: Temporary table object already in database. 
Author Message
 Err: Temporary table object already in database.
during an sp, whats the error in the following lines :

Error: Object #wordlist already in database







Whats the workaround?
any hint ??



Wed, 20 Mar 2002 03:00:00 GMT
 Err: Temporary table object already in database.

Use INSERT/SELECT instead. Try to never use select into except testing
needs - performance impact...

CREATE TABLE  #wordlist(wordid int)







---------------------------
Alexander Tarasul
MCSD,MCDBA,MCSE
Certified Borland Delphi Client Server Developer

http://pages.ripco.com/~shleym
SQL Answers at http://pages.ripco.com/~shleym/sql_answers.htm
---------------

Quote:

>during an sp, whats the error in the following lines :

>Error: Object #wordlist already in database







>Whats the workaround?
>any hint ??



Wed, 20 Mar 2002 03:00:00 GMT
 Err: Temporary table object already in database.
Alexander,

My understanding is that SELECT ... INTO ... is a non-logged operation, so
it, I would think, should have better performance than the always logged
INSERT ... SELECT.

Could you elaborate as to why you believe that INSERT ... SELECT is superior
to SELECT ... INTO from a performance viewpoint.

Thanks,

BPM


Quote:
> Use INSERT/SELECT instead. Try to never use select into except testing
> needs - performance impact...

> CREATE TABLE  #wordlist(wordid int)







> ---------------------------
> Alexander Tarasul
> MCSD,MCDBA,MCSE
> Certified Borland Delphi Client Server Developer

> http://pages.ripco.com/~shleym
> SQL Answers at http://pages.ripco.com/~shleym/sql_answers.htm
> ---------------

> >during an sp, whats the error in the following lines :

> >Error: Object #wordlist already in database







> >Whats the workaround?
> >any hint ??



Wed, 20 Mar 2002 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. ExecuteSQL Err - Table already exists

2. Err 3279: Database Already Initialized

3. Temporary Table already exists

4. object already loaded/ object variable not set HELP???

5. Temporary table in DTS -- Invalid Object Name?

6. Temporary indexes from a table containing objects

7. Where does Oracle put my temporary table objects?

8. VFP 5: error file already in use after trying to use temporary worktable again

9. VB App is creating too many temporary database objects

10. How temporary are temporary tables?

11. Add a new Database field to a already-existing Paradox table at RUNTIME

12. Temporary Database with temporary Recordset/Resultset


 
Powered by phpBB® Forum Software