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 nonclustered index on computed columns?

0 Answers  

---

What is the command used to check locks in microsoft sql server?

0 Answers  

---

How to Handle the exceptions in Sqlsrver 2005??

3 Answers   Value Labs, Wipro,

---

How to optimize stored procedure optimization?

0 Answers  

---

Which TCP/IP port does SQL Server run on?

2 Answers  

---

What is the difference between online clustering and Offline clustering?

0 Answers   IBM,

---

Where is localdb stored?

0 Answers  

---

difference between function and procedure

3 Answers   Cognizant, HCL, TCS, Theorem,

---

How to create an index on a view?

0 Answers  

---

How many triggers you can have on a table?

0 Answers  

---

how to give input dynamically to a insert statement in sqlserver

3 Answers   HCL,

---

What command is used to delete a table from the database in the sql server and how?

0 Answers  

---