Senator Guerra Souty original series calendar,replica hublot blue steel peach pointer collocation of rolex replica Rome digital scale, track type minute replica watches scale shows that the classical model is swiss replica watches incomparable, wearing elegant dress highlights.
mr-ponna.com

 

YOU ARE HERE: HOME Questions What are different types of cursors available in SQL Server 2005



Types of cursors in SQL Server 2005

View(s): 17796

What are different types of cursors available in SQL Server 2005?

Answer 1)

Following are different types of cursors available in SQL Server 2005
  1. Base table
  2. Static
  3. Forward-only
  4. Forward-only/Read-only
  5. 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.


  Asked in:  Olivegreen   Expertise Level:  Experienced
  Last updated on Sunday, 26 August 2012
3/5 stars (12 vote(s))

Register Login Ask Us Write to Us Help