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
- 20458 Views
- Adea Solutions, I also Faced
- E-Mail Answers
Answer Posted / sreyasmn
Cursors can be either updateable or non-updateable. If you
only need to display information and not diddle with it,
the non-updateable is the fastest. The provider simply
passes you the data and forgets about it! There is no need
to keep tabs on the data to see if it has been changed.
Therefore, this is the fastest cursor to use.
Cursor type
Static cursor. This is the one to use for generating
reports or finding data. Additions, changes, or deletions
by other users are not visible
Forward-only cursor. This is the default. It is identical
to the Static except that you can only scroll forward. The
fastest cursor this side of the Pecos Mountains.
Dynamic cursor. Additions and deletions by others are
visible. All movement is supported. But some providers
don't support this cursor type.
Keyset-driven cursor. This is similar to a Dynamic cursor
except you can't see records others add. If another user
deletes a record, it is inaccessible from your recordset
| Is This Answer Correct ? | 46 Yes | 13 No |
Post New Answer View All Answers
What are the new features of sql server 2012 reporting service?
Can we add a cpu to sql server?
Difference between aggregate functions of sql?
What is a with(nolock)?
What is the name of reporting services config file and what’s it’s used for?
How do I start sql server?
Tell me about normalization in DBMS.
What is the significance of master, tempdb and model databases?
What are approximate numeric data types in ms sql server?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
Where sql server user names and passwords are stored in sql server? : sql server database administration
How many types of dimensions are there and what are they? : sql server analysis services, ssas
Difference between group by clause and having clause in SQL?
What is the maximum rows in sql server table?
What is store procedure? How do they work? When do you use?
