ANSWER:
A: Use a cursor to loop through a result set one record at a time. Cursors are a strain on resources, so use query statements or stored procedures whenever possible.

Answers in Depth...