Advertisement

Server-Side Cursors — the SQL of Last Resort

  • Itzik Ben-Gan
  • Tom Moreau

Abstract

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.

Keywords

Select Statement Declare Statement Book Online Store Procedure Discount Scheme 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Itzik Ben-Gan and Tom Moreau 2000

Authors and Affiliations

  • Itzik Ben-Gan
  • Tom Moreau

There are no affiliations available

Personalised recommendations