Interested to Buy Any Domain ? << Click Here >> for more details...
What are cursors? Name four types of cursors and when each
one would be applied?
- 3 Answers
- 20457 Views
- Adea Solutions, I also Faced
- E-Mail Answers
Answer Posted / basha
Following are different types of cursors available in SQL Server 2005 :
Base table
Static
Dynamic
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.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How many categories of functions based their return modes?
Explain the dbcc pintable command when would you use it?
how to take backup bcp out for a column in table in sql server?
Explain about unique identifier data type in sql server?
How to update muliple row in single query?
What is a non-clustered index?
What is the maximum size of a dimension? : sql server analysis services, ssas
What are the limitations in ssrs on sql server express edition?
What are the pre-defined functions in the sql server?
What is the need for group functions in sql?
What is function of master database?
How to specify the collation for a character data type in ms sql server?
How to create indexed view?
When columns are added to existing tables, what do they initially contain?
What is openxml in sql server?
