C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Last 7 Days

more...

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

Cursors in SQL:

Posted Date: 29 Sep 2008 Resource Type: Articles Category: Databases

Posted By: Athira Appukuttan Member Level: Diamond
Rating:

Points: 3

Cursors in SQL:

A cursor is a database object that help in naccessing and manupulating data in given result set.
The main advantage is that we can process the data row-by -row.

There are four types cursors.

1. Static:

It alwys displays the result set as it was when the cursor opened.
statis cursors are always read-only.

2. Dynamic:
Dynamic cursors are opposite of static cursors.It refers all changes made to the rows in their result set when scrolling through the cursor.

3. Forward- Only:
The forward - only cursors does not support ; it supports
only frtching the rows serially from the start to end of the cursors.

4.Keyset-driven:
The keyset is the set of key values from all the rows that
qualified for the slect statement at the time the cursor was opened.

Responses

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

Feedbacks

Popular Tags

What are tags ?

Search Tags

Cursors in SQL: .

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: Database Normalization
	Previous Resource: Difference between Unique key and Primary Key
	Return to Discussion Resource Index
	Post New Resource
	Category: Databases

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

it help desk