What are cursors and what are the situations you will use them? | SQL Server interview questions

SQL statements are good for set at a time operation. So it is good at handling set of data. But there are scenarios where you want to update row depending on certain criteria. You will loop through all rows and update data accordingly. There's where cursors come in to picture.