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 ...
