Hooray! It’s CTE month. Some of you may be happy but you others may by like ugh. Common table expressions can be tough and confusing but WE’VE GOT YOU COVERED!
This month we will be throwing lots of valuable CTE information and resources at you including…..
- Instructional videos
- Tips of the trade
- And a FREE download!
But first here’s an very quick video explaining the availability of CTEs in SQL Server.
Transcription of video:
So common table expressions have been available since SQL Server 2005. And I really wish that I’d learned about common table expressions when they first came out. I think it was around 2010 2011 that I first learned about them. And I think in 2012 was the very first time I gave this presentation at a sequel Saturday event. Common table expressions are available on all versions of SQL Server from 2005 on including Azure SQL databases.