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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2000 Itzik Ben-Gan and Tom Moreau
About this chapter
Cite this chapter
Ben-Gan, I., Moreau, T. (2000). Server-Side Cursors — the SQL of Last Resort. In: Advanced Transact-SQL for SQL Server 2000. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-0859-4_15
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0859-4_15
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-893115-82-8
Online ISBN: 978-1-4302-0859-4
eBook Packages: Springer Book Archive