Cursor in sql server

-To fetch row by row data

1. Declare Cursor
2. Open
3. Fetch first time
   
4. fetch data until @@Fetch_Status = 0
   
5. Close
6. Deallocate

Disadvantage:
- Time Consuming
- required lot of resources & temporary storage.