Interested to Buy Any Domain ? << Click Here >> for more details...
How many types of Cursor in SQL SERVER?
- 1 Answers
- 1493 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is cursor in ms sql server?
Explain the collation?
How to find out what is the default collation in a database?
What is the recovery model?
What is a data collection table?
What are the disadvantages of indexes?
can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?
What are diverse clauses that form a part of sql?
Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.
1 Answers Cognizant, HCL, Value Labs,
What is the template in sql?
Explain user defined views?
what is hash nonclustered index
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
