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 do I view a script in sql server?

0 Answers  

---

Explain transaction server implicit?

0 Answers  

---

what is Archive old data?

1 Answers  

---

If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?

1 Answers  

---

Explain different types of self contained sub query?

0 Answers  

---

How to enter date and time literals in ms sql server?

0 Answers  

---

What is instead of trigger sql server?

0 Answers  

---

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

0 Answers  

---

What is difference between unique and primary key?

0 Answers  

---

Do you know what is openxml in sql server?

0 Answers  

---

Is sql server a database?

0 Answers  

---

do you know how to configure db2 side of the application? : Sql server database administration

0 Answers  

---