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
Is the primary key column of a table an index in ms sql server?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
What is "scheduled jobs" or "scheduled tasks"?
How is foreign key related to primary key?
What is ddl and dml commands?
Does order by actually change the order of the data in the tables or does it just change the output?
What is merge statement?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
Explain magic tables in sql server?
How to Insert multiple rows with a single insert statement?
What are parameterized reports? What are cascading parameters in ssrs reports?
Explain comment on transactions?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is the usage of the sign function?
your distribution database is full what will u do
