4 Years
Discussion Span
Last Post by adam_k

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.


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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.