what is cursor

Question

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

Anupam Singh · 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.

Khan Abrar Ahmed · Answer

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

Abhay Shanker · Answer

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

Bhabani Prasad · Answer

http://aspdotnetbank-kartik.blogspot.in/2011/12/what-is-cursorpurpose-of.html

what is cursor

Answers (4)