Abstract
Dynamic SQL presents a unique opportunity to take common database problems or limitations and solve them quickly. Oftentimes we run into frustrating situations where we are managing different databases, schemas, or settings, and there is no easy way to make changes to a mixed set of objects. This chapter provides an opportunity to explore some examples of situations where dynamic SQL can resolve complex situations. In addition, we will provide general guidelines and techniques that could apply to any similar database problem.
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
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2019 Edward Pollack
About this chapter
Cite this chapter
Pollack, E. (2019). Solving Common Problems. In: Dynamic SQL. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-4318-3_10
Download citation
DOI: https://doi.org/10.1007/978-1-4842-4318-3_10
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-4317-6
Online ISBN: 978-1-4842-4318-3
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)