Duration: 60 minutes
Track: Application & Database Development
You have been introduced to Common Table Expression, you understand the WITH syntax, but you want to know more. Learn how to recursive queries work with CTEs and how to display hierarchical data. Did you know that you can INSERT, UPDATE and DELETE data from CTEs. Some of the common use cases for CTEs will be covered including finding holes in patterns, finding and removing duplicate data, string parsing, and more. See how CTEs compare to SQL Server 2012 offset and fetch paging techniques. Get an in depth understanding of the performance behind a common table expression. Understand when the CTE is the right solution, and the wrong solution to use. Finally we will take a look at some classic recursive algorithms and how they can be implemented with CTEs. Take away several CTE samples that you can use to extend your TSQL query abilities.
To access the session recording, please login or register first:
Not a PASS member? Click here to register.
Founder / Owner, Stedman Solutions, LLC.
Steve Stedman is the Leader of a PASS Chapter in Bellingham WA USA. Steve runs his own SQL consulting firm Stedman Solutions, LLC. He has 26 years of programming and SQL experience. He has written... View More