What is the need of cursor?

Question

Can some one tell me the usage of cursor what is the need of it and where we have to use it? Thanks.

Suthish Nair · Answer

Try to avoid using cursors is the best way for query performance. http://forums.asp.net/t/1244649.aspx/1

Amit Choudhary · Answer

Basic ideas are: Cursor is a record set use to hold the data temporarily in the form of rows. It can be filled by a select statement. Cursor are always work in a forward mode that means once you navigated to the next row in record set you can't come back just like your SqlDataReader class. This behavior makes them faster.

Jiteendra Sampathirao · Answer

Are you asking about cursor related to Database or windows icon. If windows icon: refer Link Database related: refer link1: Link2

Muralidharan Deenathayalan · Answer

Please read our recommended article section. http://www.c-sharpcorner.com/UploadFile/skumaar_mca/CursorsAlternative09012009011823AM/CursorsAlternative.aspx