What is the difference between HAVING clause and the WHERE clause?

7 Answers  

---

How many types of system privileges are there, Can we add or delete privileges?

2 Answers  

---

How you can get a list of all the table constraints in a database?

0 Answers  

---

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  

---

diffrence between function and procedure

5 Answers   Wipro,

---

What is the difference between constraints and triggers?

9 Answers   Wipro,

---

what is DTS what are tasks available

1 Answers   Wipro,

---

How to insert stored procedure result into temporary table?

0 Answers  

---

In the primary key have a multiple field or not?

8 Answers   TCS,

---

List the various tools available for performance tuning?

0 Answers  

---

Differences between logshipping and mirroring

1 Answers   Microsoft, Syntel,

---

What’s the distinction between dropping a info and taking a info offline?

0 Answers  

---