What is the real use of Sql cursor ?

Question

What is the main basically use of sql cursor ? How can we use them in our project ?

Hiten Pandya · Answer

Cursor comes to the picture when there is a scenario of Multiple records and from that multiple records you want to use each and every records for future process just like for loop or any kind of loop which allow us to work with a single record from a list of records.

Suraj Kumar · Answer

You can follow the link for cursor https://www.mssqltips.com/sqlservertip/1599/sql-server-cursor-example/

Amit Kumar · Answer

Hi Cursor is used for retrieving data row by row basis.its act like a looping statement (ie while or for loop). If you want to update only 10 rows outof 2000 rows in a table then it use.

Prateek Singla · Answer

http://www.c-sharpcorner.com/UploadFile/63f5c2/cursor-in-sql-server/

Laxmidhar Sahoo · Answer

sir incase of sql query you read records dynamicaly(all rows value gets at a time ). where as when the query ready throw cursor you can read records explicitily (each row value can get separatily)