A Virtual FROM Source

Question

A Virtual FROM Source

Steve Jones - SSC Editor

SSC Guru

Points: 738357
More actions
February 2, 2022 at 12:00 am

#3969933

Comments posted to this topic are about the item A Virtual FROM Source

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

edwardwill SSCertifiable Points: 5952 More actions · Answer 1

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.

mkdm Ten Centuries Points: 1098 More actions · Answer 2

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 :).

edwardwill SSCertifiable Points: 5952 More actions · Answer 3

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.