Details

Dynamic SQL: Tables, Pivots

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


Back to Top
cage-aids
cage-aids
cage-aids
cage-aids