C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Abhi (63)
Appukuttan (40)
divya (36)

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

Cursors and it's Structure

Posted Date: 19 Jun 2008	Resource Type: Definitions	Category: General
Author: Bunty	Member Level: Diamond
Rating:	Points: 5

A cursor is a database object that helps in accessing and manipulating data in a given result set.The main advantage of cursors is that you can process data row-by-row.

A result set is defined as a collection of rows obtained from a SELECT statement that meet the criteria specified in te WHERE clause.

Cursors,therefore,serve as a mechanism for applications to operate on a single row or a set of rows.Cursors enable the processing of rows in the given result set in the following ways:

1>Allow specific rows to be retrieved from the result set.
2>Allow the current row in the result set to be modified.
3>Help navigate from the current row in the result set to a different row.
4>Allow data modified by other users to be visible in the result set.

Structure of Cursors:
The following tasks need to be performed while using a cursor in SQL Server:

1>The cursor needs to be defined and its attributes need to be set.
2>The cursor needs to be opened.
3>The required rows need to be fetched from the cursor.Fetch refers to the process of retrieving a row from the result set.
4>The data in the current row of the cursor can be modified,if required.
5>The cursor needs to be closed.
6>The cursor should be deallocated.This is a good practice as resourses used by the cursor are released.

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Structure of a cursor . Definition of a cursor . Cursors definition . Cursors and their structure . Cursors . Cursor and it's stucture .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Difference B/W response.redirct() and server.transfer()
	Previous Resource: What is a Trigger?
	Return to Discussion Resource Index
	Post New Resource
	Category: General

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design