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.

What is the bookmark lookup and rid lookup?

0 Answers  

---

What are the main differences between #temp tables and @table variables and which one is preferred?

0 Answers  

---

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers   HCL,

---

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

0 Answers  

---

How to trouble shoot if unable to connect SQL Server

0 Answers  

---

---

can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 Answers  

---

How to add additional conditions in SQL?

0 Answers   Amdocs,

---

How to loop through result set objects using odbc_fetch_row()?

0 Answers  

---

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

0 Answers   IBM,

---

What happens if date-only values are provided as date and time literals?

0 Answers  

---

What is the difference between implicit and explicit transaction?

0 Answers  

---

What are the tool windows in sql server management studio? : sql server management studio

0 Answers  

---