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.

How to provide default values to stored procedure parameters?

0 Answers  

---

Explain the dbcc pintable command when would you use it?

0 Answers  

---

What is trigger in salesforce?

0 Answers  

---

Do you know what is difference between index seek vs. Index scan?

0 Answers  

---

What are sub-queries? Give example? In which case sub-queries are not feasible?

4 Answers   Infosys,

---

How can I create a table from another table without copying any values from the old table?

3 Answers  

---

What is sql server schema compare? How we can compare two database schemas?

0 Answers  

---

How to add additional conditions in SQL?

0 Answers   Amdocs,

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

---

What are the system database in sql server 2005?

0 Answers  

---

Difference between primary key and clustered index?

0 Answers  

---

Explain a differential backup?

0 Answers  

---