O'Reilly logo

Dynamic SQL: Applications, Performance, and Security by Edward Pollack

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© Ed Pollack 2016

Edward Pollack, Dynamic SQL, 10.1007/978-1-4842-1811-2_10

10. Solving Common Problems

Edward Pollack

(1)Albany, New York, USA

Dynamic SQL presents a unique opportunity to take common database problems or limitations and solve them quickly. Oftentimes, you’ll run into frustrating situations where you are managing different databases, schemas, or settings, and there is no easy way to make changes to a mixed set of objects. This chapter attempt to show you how Dynamic SQL can resolve complex situations such as these. In addition, this chapter provides general guidelines and techniques that could apply to any similar database problem.

Collation Conflicts

The Problem

Database collations are often used as a way to manage multiple languages ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required