Dynamic SQL is SQL that created and executed at run-time. It sounds complicated, but it really isn’t. Dynamic SQL is useful in solving many tasks. But it does bring with it risks. About the advantages and threats of dynamic SQL will be this article. Traditionally, in my opinion the best way to learn is through video tutorials. 32 minutes of watching and 1 minutes of reading. Let's get started.
What is dynamic SQL? What is SQL Injection?
This lesson will introduce you to dynamic SQL issues.
EXEC and sp_executesql
It's time to take a closer look at two commands: EXEC and sp_executesql.
In this video you will see the practical use of dynamic SQL.
Dynamic Pivot and Unpivot
Dynamic SQL is often used to implement pivot or unpivot data.