Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / anindya basu
There are four types of cursor in SQL Server which are:
a. Static
b. Dynamic
c. Forward Only, and
d. Keyset
Static keysets aren't sensitive to database changes and are scrollable.
Dynamic keysets are sensitive to database changes and are scrollable.
Forward only keysets aren't sensitive to database changes and allows only forward scrolling of data. There are 3 variants of Forward Only cursors viz. Forward Only Static, Forward Only Keyset, and Fast Forward. Fast Forward is the fastest of all cursors.
Keyset cursor supports movement from the first row to the last and vice-versa. It doesn't identify inserts but recognizes both updates and deletes.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the difference between HTTP and HTTPS in database?
Explain linked server in sql?
Why Master database is required?
How to connect a database with sql express.?
Define self join?
What are the differences between union, intersect, and minus operators?
What samples and sample databases are provided by microsoft?
Will count(column) include columns with null values in its count?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
What are the advantages to use stored procedures?
Explain having clause and where clause?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
Is oracle faster than sql server?
How you can find out if an index is useful to the optimizer?
What is the function of sql server agent windows service?
