In this short but to the point video Steve explains the question “what is a CTE?”
Transcription of this video:
CTE is kind of this concept of what we’re calling a virtual table where it’s like a sub query or like a view where it’s referencing another chunk of SQL query that’s going to be used and named. Similar to the ease of using a temp table. And I’m kind of using a lot of sort of VHS and kind of likes here because it’s sort of like a drive table. But it behaves a little bit differently. To say maybe behaves is not the right word. It’s, coded a little bit differently when you’re using it. And it’s kind of like a temporary name results that if there was a concept of being able to create a temporary view or a Runtime view, that’s kind of how a CTE works.
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!