Answer / rajesh k gupta

Temp Table whether it is local temp which is naming with
single # or global with ## is stored in tempdb database.
it can be seen by exploring the databsse. if it is local
temp table it would be droped once user ends the session,
so you will have to ensure that you are using this table in
the same session where it has been created.
Sysntax to retrieve data frm a temp table is as follows:-
select field1,field2.....fieldN from #tablename

What is SCSI (Small Computer System Interface)?

0 Answers   Zenith,

---

Is it possible to log the messages on the service side? On the client side? How to switch on the logging?

1 Answers  

---

can u tel me how we can use temp table in sql sserver instead of Dual in oracle?

1 Answers  

---

What is SMTP (Simple Mail Transfer Protocol) ?

0 Answers  

---

What are FMSO Roles? List them...

4 Answers   DynPro,

---

What is Xeon Processor Technology?

0 Answers   Intel,

---

What is microsoft register server?

0 Answers  

---

hi iam using window 2003 server,in that iam using remote instalation service (instaling oparating system through remotely) in my client machine gave a error like "the network adaptor is not present in your image " pls send me solution as soon as possible

1 Answers  

---

What is the latest microsoft?

0 Answers  

---

What is the difference between microsoft edge and internet explorer?

0 Answers  

---

What is DS Proxy?

1 Answers   Deloitte,

---

What is CPU (Central Processing Unit)

0 Answers   CMS,

---