what is cursor

snowal raj

12y1.2k

what is cursor and how to use the cursor and how to use the cursor in c#

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Anupam Singh12y ago
Accepted answer
Hi snowal,

Actually I saw you article and waiting for correction by your side.
Because C# and Cursor both are quite different.

Cursor is a feature of SQL Server and it works like foreach loop in C#.
you can find simple cursor example here

So we dont use cursor in C# ,we prefer foreach.

I would recommend you to do so.

0
Khan Abrar Ahmed12y ago
Hi, Refre this

http://msdn.microsoft.com/en-us/library/ms181441.aspx
http://www.sqlservergeeks.com/articles/sql-server-bi/31/sql-server-what-is-a-cursor
0
Abhay Shanker12y ago
Cursors are database objects used to manipulate data in a set on a row-by-row basis; it acts just like a recordset.We can also fetch cursor rows and perform operations on them in a loop just like using any looping mechanism found in any other programming language. Before you can use a cursor, you need to declare it.
Cursor can also be defined as a set of rows together with a pointer that identifies a current row
DECLARE cursor_name CURSOR
[LOCAL | GLOBAL] --define cursor scope
[FORWARD_ONLY | SCROLL] --define cursor movements (forward/backward)
[STATIC | KEYSET | DYNAMIC | FAST_FORWARD] --basic type of cursor

[READ_ONLY | SCROLL_LOCKS | OPTIMISTIC] --define locks
FOR select_statement --define SQL Select statement
FOR UPDATE [col1,col2,...coln] --define columns that need to be updated
For more detail check below urls
http://msdn.microsoft.com/en-us/library/ms181441.aspx
http://www.sqlservergeeks.com/articles/sql-server-bi/31/sql-server-what-is-a-cursor
0
Bhabani Prasad12y ago
http://aspdotnetbank-kartik.blogspot.in/2011/12/what-is-cursorpurpose-of.html
0