Server-Side Cursors — the SQL of Last Resort
If you have skipped through the previous chapters so that you could get to this one right away, stop! Most cases where cursors are being used, they are not really necessary. Cursors are not as clean as using straight SQL, both from a coding and performance standpoint. You should look upon cursors as the SQL of last resort, and it had better be the last resort. SQL was designed to be used for set-level (non-cursor) solutions and can handle just about anything you throw at it without the need for a cursor. Sometimes, though, there is no escaping cursors. This chapter will guide you through their proper usage.
KeywordsSelect Statement Declare Statement Book Online Store Procedure Discount Scheme
Unable to display preview. Download preview PDF.