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.
| Author |
Topic |
|
subbi39
Starting Member
11 Posts |
 Posted - 2009-05-27 : 00:41:39
|
| Dear All, what are #tables? and what is the purpose and where they are stored.thanks in advance |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-05-27 : 00:46:20
|
quote:
what are #tables? and what is the purpose and where they are stored.
Temp Table. Temporary table only exists and accessible only within the session context and it is located in tempdb database. It is used for temporary storage.see the BOL here http://msdn.microsoft.com/en-us/library/ms174979(SQL.90).aspx
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-27 : 10:10:19
|
| http://databases.aspfaq.com/database/should-i-use-a-temp-table-or-a-table-variable.html |
|
|
|
|
|
|
#tables