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 you stop stored procedures from recompiling?

0 Answers  

---

What is Outter Join?

1 Answers  

---

How to disable a login name in ms sql server?

0 Answers  

---

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

What is difference between inner join and full join?

0 Answers  

---

Mention the uses of stored procedures.

0 Answers  

---

What is sql server programming?

0 Answers  

---

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

0 Answers  

---

Give an example of SQL injection attack ?

0 Answers   HAL,

---

what is normalization? : Sql server database administration

0 Answers  

---

What is the difference between temp table and table variable?

8 Answers   Microsoft,

---