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 does it mean to normalize data?

0 Answers  

---

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

0 Answers  

---

What are various aggregate functions that are available?

0 Answers  

---

Where are sql server usernames and passwords stored in the sql server?

0 Answers  

---

hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table

7 Answers   Indecomm,

---

What is equi join with example?

0 Answers  

---

How to use linked server?

0 Answers  

---

What is a view? is View updatable?

17 Answers   IBM, L&T,

---

Explain user defined functions?

0 Answers  

---

How do I find the sql server database version?

0 Answers  

---

What are the types of indexing?

0 Answers  

---

What is explicit mode in sql server?

0 Answers  

---