Temp table in sql for all user

Question

hello,
i dont know how to handle the temp table by sql server
my question is if i create a temp table by storeproducer. In my website user online 2000 at a time then this table create for all user
i mean this temp table handle all user by single temp or sql create 2000 table for all user ,
so please tell me working of temp table in MS SQL 2008
thanks

Anuja Pawar · Answer

Yes you can. Read this article to gain more knowledge on Temp table
http://techahead.wordpress.com/2007/09/27/sql-temporary-tables/

Dharmesh Sharma · Answer

thanks for your reply ,
so we can not perform delete update opration in temp table
right

Anuja Pawar · Answer

A local temporary table created in a stored procedure is dropped automatically when the stored procedure completes. So when your procedure is called a temp table will be created, but at the end will be destroyed too. So if it is a requirement then no harm in having temp table.