Sunday, April 3, 2016

Dynamic SQL

Dynamic SQL

Example from AdventureWorks:

Dynamic SQL and Procedures:

SQl Server Dynamic SQL:

Dynamic SQL / Adhoc SQL (6 min short video):

Table names would vary at run time and schema would vary at runtime:


  1. Nice post...I look forward to reading more, and getting a more active part in the talks here, whilst picking up some knowledge as well..

    Pass Box manufacturers