What is a CTE? – Video Explanation

What is a CTE? – Video Explanation
Download PDF

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:

SteveStedman5
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!

Leave a Reply

Your email address will not be published. Required fields are marked *

*