Member Avatar for pratham3090

What is cursor in SQL and when to use

Edited by pritaeas because: Moved. Database question.
  • 3 Contributors
  • 2 Replies
  • 131 Views
  • 16 Hours Discussion Span
  • Latest Post Latest Post by adam_k

Recommended Answers

All 2 Replies

Member Avatar for pritaeas

A cursor is basically a table, generated from a query, so you can iterate through the rows. It is usually used in a stored procedure or trigger.

Member Avatar for adam_k

A cursor is the tool we've got to iterate through records.
You can loop through the results of your query and do whatever you have to do with each record.
I've got to disagree with pritaeas on the sp or triggers part. You use a cursor when you need to handle each record differently, in a specific order where a case won't cover things. Usually they are too expensive (in terms of resources) and don't get the job done as fast as processing bulk data would.

Edited by adam_k
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.