Answer / ramya gurrala

Cursor is a pointer(in c/java).Cursor work with DML and information can be accessed.

Cursor is required to process each row individually for queries which return multiple rows.

Advantages:1)We can do operations on each row.
2)Response time is good.
3)Cursors are faster than the while loop.

Disadvantages:1)Repeated network round trips.
2)Occupies more resources and temporary storage.

How can I enforce to use particular index?

1 Answers   Symphony,

---

can you tell me some sites name for sql server 2000 commands with example??? plz reply soon.

0 Answers  

---

What are key constraints?

0 Answers  

---

What authentication modes does sql server support?

0 Answers  

---

What is Self Join?

4 Answers  

---

---

In which files does sql server actually store data?

0 Answers  

---

Why we use the openxml clause?

0 Answers  

---

How to check table values in sql server?

0 Answers  

---

How sql server executes a statement with nested subqueries?

0 Answers  

---

What is difference between clustered and non clustered index?

0 Answers  

---

between cast and convert which function would you prefer and why?

0 Answers  

---

What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.

3 Answers   247Customer,

---