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)
 Temp tables

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-12-07 : 21:39:32
Kaushik writes "Hello
I have seen many questions asked at sqlteam.com and have seen the replies to this questions and in those replies i have seen u have created temp. tables. My questions is that if suppose i have a procedure in which i am creating this temp. table and dropping it, and at a given moment thousand calls are made for this procedure, will the names conflict, or there is some other problem. Creating 1000 temp tables, will it be good idea and also will it slow down the output or will it increase it.
And also please let me know why this temp. table concept is so very much used"
   

- Advertisement -