Dynamic SQL: Tables, Pivots

Steven Tidwell
60 minutes
SQL Server Development
Dynamic SQL is a scripting language that helps you design flexibility into your code. It allows you to design solutions, pass parameters and allows you build a single query on values passed. Dynamic SQL has both pros and cons to it's design, but can also be a helpful tool. This presentation will walk through the steps of building dynamic tables, aggregating data in a pivot format and give you the first steps of writing a Dynamic Query. There are hundreds of task that will benefit from the use of Dynamic SQL. From parameter based searches to building dynamic SELECT statements at run time.

Back to Top cage-aids