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.