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 difference between commit and rollback when used in transactions?

0 Answers  

---

What is the difference between insensitive and scroll cursor?

0 Answers  

---

What is difference between index seek vs. Index scan?

0 Answers  

---

What is the use of SCOPE_IDENTITY() function?

2 Answers  

---

What is the command used to recompile the stored procedure at run time?

0 Answers  

---

---

Explain DBMS, RDBMS?

6 Answers  

---

What is the use of partition by in sql server?

0 Answers  

---

Define union, union all, minus, intersect?

0 Answers  

---

Can we insert data into view sql server?

0 Answers  

---

What is the Disadvantage of indexed sequential file.

0 Answers   HCL,

---

What do you understand by coalesce in sql server?

0 Answers  

---

How to use "begin ... End" statement structures in ms sql server?

0 Answers  

---