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 |
|
lici
Starting Member
11 Posts |
 Posted - 2004-06-15 : 18:28:12
|
| Hi everybodyI have a question abolut tables created with caracter #. My question is about where is stored the information of this tables, I mean, the records from this tables are stored in RAM on the client, or in RAM on the server, or in database temp_db . And wich is the diference between use one # and use two ##, I know that one of the diferences is that with one # the tmp table just can be accesed on the active session , and using double # allows to acces the table from multiples instances in the same conection, are there others differences?Thanks !!!! |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-06-15 : 19:14:57
|
| There are many articles here at SQLTeam regarding Temp Tables:Have a look:http://www.sqlteam.com/searchresults.asp?SearchTerms=temp+tables |
 |
|
|
|
|
|
Tmp tables