Answer / Ganesh Soni

Global temporary tables (GTTs) in SQL Server are prefixed with two '#' symbols. They can be accessed by any user session that connects to the instance of SQL Server after their creation. Their scope ends when the connection ends, or explicitly dropped. If no connection is accessing a GTT, it will be automatically dropped.

How to update multiple rows with one update statement in ms sql server?

1 Answers  

---

write down the code for "how we delete a table without using of Drop command " ?

7 Answers   CarrizalSoft Technologies, Sonata,

---

How to join two tables in a single query in ms sql server?

1 Answers  

---

How to enter comments in transact-sql statements?

1 Answers  

---

How do you trace the traffic hitting a sql server?

1 Answers  

---

What is primary key and example?

1 Answers  

---

What are commonly used mssql functions in php?

1 Answers  

---

Do you have any idea about the tcl commands?

1 Answers  

---

can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?

1 Answers  

---

What is difference between cte and view?

1 Answers  

---

difference between sql server2000 and sql server2005

1 Answers   KPMG,

---

What are the types of database schema? : sql server analysis services, ssas

1 Answers  

---