SQL Server Programming Part 11 - Common Table Expressions (CTEs)

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould

https://www.wiseowl.co.uk - A Common Table Expression in SQL is a technique for creating a temporary recordset that you immediately use in another statement - they're often a neat alternative to using Temporary Tables. In this video we'll teach you how to create and consume a CTE, show you a couple of practical uses for them and hopefully convince you that they're worth using!

You can see a written version of this tutorial at:
https://www.wiseowl.co.uk/blog/s184/cte-sql.htm

You can download the script to create the Movies database used in this video at the following link:
https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip

You can see the range of resources and courses we offer in SQL Server here:
https://www.wiseowl.co.uk/sql/

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!

Видео SQL Server Programming Part 11 - Common Table Expressions (CTEs) канала WiseOwlTutorials