Answer / radha

A local temporary table exists only for the duration of a
connection or, if defined inside a compound statement, for
the duration of the compound statement.

A global temporary table remains in the database
permanently, but the rows exist only within a given
connection. When connection is closed, the data in the
global temporary table disappears. However, the table
definition remains with the database for access when
database is opened next time.

Explain about unique identifier data type in sql server?

0 Answers  

---

How to update muliple row in single query?

0 Answers   MCN Solutions,

---

What are mdf,ndf,ldf files and how to see the data in those files?

6 Answers   Accenture,

---

Explain what are partitioned views and distributed partitioned views?

0 Answers  

---

How to modify existing triggers using "alter trigger"?

0 Answers  

---

---

How to rebuild all indexes on a single table?

0 Answers  

---

WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

1 Answers   Synergy,

---

How to update values in a table with update statements in ms sql server?

0 Answers  

---

What is the difference between functions and stored procedures?

0 Answers   Accenture,

---

Where the sql logs gets stored?

0 Answers  

---

Difference between Cluster and Non-cluster index?

32 Answers   Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,

---

Explain the different types of joins?

0 Answers  

---