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 the basic diffrence betn a col declared in char(1) and in varchar(1)

2 Answers  

---

How to select an exiting database using mssql_select_db()?

0 Answers  

---

How to find the last update record in SQL Server?

4 Answers  

---

What is set nocount on and what is set nocount off?

0 Answers  

---

Explain different types of locks in sql server.

0 Answers  

---

How can you find out which stored procedures are recompiling?

0 Answers  

---

Write a query to find 5th highest amount paid from the customer table.

0 Answers  

---

What is create command?

0 Answers  

---

what is cursor?why we will go to cursor?advantages &disadvantages of cursors?

1 Answers  

---

What are different types of raid levels?

0 Answers  

---

How to use union to merge outputs from two queries together in ms sql server?

0 Answers  

---

What is self join in sql server joins?

0 Answers  

---