Dynamic SQL 1 in 5 Minutes

Morelan describes Dynamic SQL as putting a puzzle together and when the pieces are together you finally see what it says. To do this you need to run the statement and produce results, Morelan covers this and how to do it throughout the video.

If you thought this short blog was helpful, check out our Developer 2012 volume 4 14.1 class for a deeper dive into Dynamic SQL. We strive to be your leading authority in SQL so please give us feedback if you need to see something more.

Be sure to tune in next week, we are going to be discussing SQL Injections. For our previous blogs, please refer to the archive.

[ibrahimmaher]

how to pass a varchar field to where criteria like
DECLARE @Where [nvarchar](50)='FirstName=' +'Nancy''
return error "Invalid column name ''Nancy"

[gotchihaeyo]

I guess I understand how it works but why not explaining why we need it??

[liquidcode]

DO's: implement this on your own local machine for your own research
DONT's: use dynamic sql in an api