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.

What is 2nf normalization form?

0 Answers  

---

Explain the database you used in your final year project?

0 Answers   Wipro,

---

What is service broker? : sql server database administration

0 Answers  

---

What are the operating modes in which database mirroring runs?

0 Answers  

---

How to replace the Query Result 'Null Value' with a text ?

0 Answers   MCN Solutions,

---

---

how to find number of columns in a table in sql server 2000 and 2005 also

16 Answers   Virtusa,

---

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

0 Answers  

---

What is resultset concur_updatable?

0 Answers  

---

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

0 Answers   TCS,

---

how to find out the repeated value from table using groupby function?

4 Answers  

---

how to avoid cursors? : Sql server database administration

0 Answers  

---

List the ways in which dynamic sql can be executed?

0 Answers  

---