Home
|
Tutorial
|
Articles
|
Forum
|
Interview Question
|
Code Snippets
|
News
|
Fun Zone
|
Poll
|
Web Links
|
Certification
|
Search
Welcome :
Guest
Sign In
Register
Win Surprise Gifts!!!
Congratulations!!!
Top 5 Contributors of the Month
ffttt
Home
>>
Interview Question
>>
Sql Server
>>
Post New Question
Subscribe to Interview Questions
What are cursors?
Posted By :
nishithraj
Posted Date :
November 30, 2009
Points :
10
Category :
Sql Server
A cursor is a moving placement or pointer that indicates a position. Cursors can be used While moving through the records
You can also find related Interview Question to
What are cursors?
below:
Explain different types of cursors.
Implicit cursors:
these cursors are invoked implicitly. User need not create, open, fetch or close the cursor.
Explicit cursors:
these cursors are not invoked implicitly. User needs to create, open, fetch or close the cursor.
Static Cursor:
Stores a complete copy of the result set. Used mostly where scrolling is required. Static cursors don't support updates.
Forward -only cursors:
This cursor supports updates but not scrolling. It supports only fetching serially. Rows are not retrieved from the database until they are fetched.
Forward - only cursors /Read only cursor:
These are the fastest of the cursors and cannot be updated. They cannot be created on query that returns only read only columns.
Key set driven:
It is a scrollable cursor that cannot be updated. These cursors are controlled by a set of physical identifiers called as key set. The keyset is built in a temporary table when the cursor is opened.
(More...)
What are cursors?
Cursors help us to do an operation on a set of data that we retrieve by commands such as Select columns from table. For example : If we have duplicate records in a table we can remove it by declaring a cursor which would check the records during retrieval one by one and remove rows which have duplicate values.
(More...)
What are cursors?
Static,
Dynamic,
Forward-only,
Keyset-driven.
(More...)
What is mean by cursors?
row-by-row processing of the result sets
(More...)
What are different types of cursors available in SQL Server?
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.
(More...)
What are Cursors?
A cursor is a temporary work area created in the system memory when a SQL statement is executed. A cursor contains information on a select statement and the rows of data accessed by it.
This temporary work area is used to store the data retrieved from the database, and manipulate this data. A cursor can hold more than one row, but can process only one row at a time. The set of rows the cursor holds is called the active set.
(More...)
Quick Links For Interview Questions Categories:
ASP.Net
Windows Application
.NET Framework
C#
VB.Net
ADO.Net
Sql Server
SharePoint
Silverlight
OOPs
JQuery
JavaScript/VBScript
Biztalk
Patten/Practices
.IIS
WCF
WPF
WWF
Networking
Aptitude
Others
All
Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.
Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.
So, Start looking our
Interview Question
section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.
Hall of Fame
Twitter
Terms of Service
Privacy Policy
Contact Us
Archives
Tell A Friend