Dynamic SQL: Tables, Pivots

Speaker(s)Steven Tidwell

Duration: 60 minutes

Track: 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.

Accompanying Materials:

No material found.

Back to Top