Dynamic SQL for beginners in 33 minutes

,

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.

Refreshing views

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.

Rate

1 (5)

Share

Share

Rate

1 (5)