Answer 1)
Following are different types of cursors available in SQL Server 2005 - Base table
- Static
- Forward-only
- Forward-only/Read-only
- Keyset-driven
Base table: Base table cursors are the lowest level of cursor available. Base table cursors can scroll forward or backward with minimal cost, and can be updated Static: Cursor can move to any record but the changes on the data can’t be seen. Dynamic: Most resource extensive. Cursor can move anywhere and all the changes on the data can be viewed. Forward-only: Cursor moves one step forward, can’t move backwards. Keyset-driven: Only updated data can be viewed, deleted and inserted data cannot be viewed.
|