What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

0 Answers  

---

Tell me what is log shipping?

0 Answers  

---

What is full form of XP ?

42 Answers   Cap Gemini, Infosys, Microsoft, Oracle, Reliance,

---

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

0 Answers  

---

‘Order by’ is not allowed in a view how can you sort information from a view?

0 Answers  

---

---

How to create nested stored procedure?

0 Answers  

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

Differentiate between ms sql server reporting services vs crystal reports?

0 Answers  

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

0 Answers  

---

How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com

35 Answers   Oracle, Scend, TechInfini,

---

How do you create a clustered index?

0 Answers  

---

What is update locks?

0 Answers  

---