Answer Posted / vikash kumar mishra

There are five type of cursors in SQL server.
1)Base table:- This is lowest level cursor.

2)Static :- This is scrollable query cursor in earlier
versions of SQL Server Compact Edition

3)Forward-only:- The forward-only cursor is the fastest
cursor that you can update, but it does not support
scrolling.

4)Forward-only/Read-only:- Forward-only/read-only cursors,
referred to as forward-only cursors in earlier versions of
SQL Server Compact Edition, are the fastest cursors, but
cannot be updated.

5)Keyset-driven:- The keyset-driven cursor in SQL Server
Compact Edition is a scrollable cursor that you can update.
A keyset-driven cursor is controlled by a set of physical
identifiers known as the keyset.

How to recover from sql injection? : sql server security

1006

---

what is dbcc? : Sql server database administration

1022

---

How to insert stored procedure result into temporary table?

1011

---

Is sql server is free?

971

---

How can I add Reporting Services reports to my application?

129

---

Explain what is meant by replication of database?

1025

---

What is change tracking in sql server?

1000

---

What is linked report?

131

---

What is model database in sql server?

1046

---

Does table partitioning improve performance?

957

---

What is database dimension? : sql server analysis services, ssas

1071

---

What is the maximum row of a size?

1012

---

Can you index views?

891

---

What is sparse columns of sql server 2008?

1040

---

What are difference between Cluster index and Non-Cluster index?

1068

---