Please differentiate between a local and a global temporary table?

0 Answers  

---

how to get the salary in descending order with out using the keyword desc in sql

5 Answers   Ramco,

---

What are the types of joins in sql?

0 Answers  

---

How would we use distinct statement? What is its use?

0 Answers  

---

Explain sql server service broker?

0 Answers  

---

---

Can we rollback records deleted by a truncate statement?

3 Answers   CarrizalSoft Technologies, United Healthcare,

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

0 Answers  

---

How can we remove orphan records from a table?

0 Answers  

---

What are built in functions?

0 Answers  

---

How to find the version of sql server? : sql server database administration

0 Answers  

---

How can you tell if a database object is invalid?

0 Answers   MCN Solutions,

---

Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?

4 Answers  

---