February 2, 2022 at 12:00 am
Comments posted to this topic are about the item A Virtual FROM Source
February 2, 2022 at 9:30 am
I'm afraid I take issue with the question. I answered CTE because a CTE is neither a table nor a view and
SELECT * FROM MyCte
is perfectly valid.
February 2, 2022 at 2:03 pm
Right, a CTE can dynamically construct a table the same as a VALUES clause. It wouldn't be nice for very many rows, though -- but that wasn't the question :).
February 2, 2022 at 2:10 pm
The question was "I want to get some data in a SELECT statement, but I don't have a table or view that matches my needs. What can I put into the FROM clause that will let me specify the data I need?" A CTE is neither a table nor a view. It might resemble one, but it isn't one, otherwise it would be called a table or a view.
February 2, 2022 at 2:34 pm
I'm agreeing with you :).
February 2, 2022 at 2:39 pm
Cool, sorry - I misread your comment ;¬}
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy