Sql Server Temporary Tables

itHighway · July 13th, 2005, 10:28 AM

Hello!

This is the first time I am working on Sql Server stored procedures and Temporary Tables. My question is regarding Temporary Tables.

My database consist of 10000+ records, Visitor comes and search different articles in it. Now suppose a visitor comes and searches "Fishing flies and dries". All the results from database will be stored in Temporary Table.
Now at the same time second visitor comes and searches "Cities of Australia". The results from this search will also save in Temporary Table.

What I want to know is will the search by second Visitor will effect the search results of first Visitor?

Actually, what I have in my mind is the search results of second visitor will replace the search results of first visitor in temporary table. Is this Correct?

Thanks!
Zeeshan Ahmed

jbenson001 · July 14th, 2005, 12:33 AM

No it will not replace the first visitor's results. Although the temp table name is the same in the SP (Ex #temp1), behind the scenes, SQL Server gives the table name a unique value(Ex: #temp1_XyoudfE34242). It concatinates some string based on some criteia to make iu unique.