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.

Some queries related to SQL

1036

---

How can we determine what objects a user-defined function depends upon?

1067

---

What do you mean by data integrity?

1126

---

How to connect Azure federated root database and apply federation in entity framework?

109

---

How to send email from database?

1070

---

What is the cartesian product of the table?

1003

---

What are the dis_advantages of stored procedures, triggers, indexes?

2273

---

How can sql server instances be hidden?

1028

---

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

1030

---

What is the difference between grant and with grant while giving permissions to the user?

1024

---

Explain steps of normalization?

1062

---

What is a deadlock and what is a live lock?

1040

---

How to trouble shoot if unable to connect SQL Server

2028

---

explain databases and sql server databases architecture? : Sql server database administration

1012

---

What do you mean by stored techniques? How would we use it?

1079

---