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
How to convert a table data in XML format in sql server?
Can you please differentiate between a primary key and a unique key?
Can we call stored procedure in view in sql server?
What command is used to delete a table from the database in the sql server and how?
Is mysql better than sql server?
Is foreign key unique?
What do you understand by the denormalisation?
How to apply cascading referential integrity in place of triggers?
What is co-related sub query?
What is built-in/administrator?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
tell me the disaster recovery plan
How many instances per computer are there in sql server 2000?
Explain cdc and sql injection?
Which table keeps information about stored procedures?
