Mastering Dynamic SQL

Deborah Melkin

Dynamic SQL has a bad reputation. Some of it is even deserved. However, dynamic SQL can be a great tool to have in your toolbox when used correctly.

In this session, we’ll dive into creating and troubleshooting dynamic SQL. We will start by examining various scenarios that would be good candidates for implementation. Then we’ll take a look at how it executes under the covers. We’ll consider smarter and safer ways of crafting our SQL statements, and explore error handling and debugging as well.

You will leave this session with a better understanding and appreciation for how dynamic SQL works as well as why and when to use it.