Explain differentiate between a having clause and a where clause?

0 Answers  

---

Can we perform backup restore operation on tempdb?

0 Answers  

---

HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY IN EMP TABLE

18 Answers   Infosys, TCS,

---

What is policy based management (pbm)? : sql server database administration

0 Answers  

---

How do I find query history in sql server?

0 Answers  

---

---

What is the difference between dropping a database and taking a database offline?

0 Answers  

---

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

0 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers   HCL,

---

What are commit and rollback in sql?

0 Answers  

---

What is a benefit of using an after insert trigger over using a before insert trigger?

0 Answers  

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---

What are tables in sql server?

0 Answers  

---