Explain try...catch with sql server?

0 Answers  

---

How to create an index on an existing table in ms sql server?

0 Answers  

---

Explain trigger classes i.e. Instead of and after trigger?

0 Answers  

---

How do you know if sql server is running on your local system?

0 Answers  

---

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---

Difference between group by clause and having clause in SQL?

0 Answers   Flextronics,

---

What is a covering index?

0 Answers  

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

7 Answers   Microsoft,

---

What is the difference between cross join and Full outer join?

1 Answers   HP, Standard Bank,

---

Explain various On-Delete options in a DB table. Which is the default option?

0 Answers   Akamai Technologies,

---

What is an indexing technique?

0 Answers  

---

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

11 Answers   World Tech, Yardi Software,

---