Query the Column Set

Question

Query the Column Set

Steve Jones - SSC Editor

SSC Guru

Points: 734434
More actions
September 24, 2018 at 8:20 pm

#100984

Comments posted to this topic are about the item Query the Column Set

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

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

Stewart "Arturius" Campbell SSC Guru Points: 72497 More actions · Answer 1

Nice question, thanks Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

edwardwill SSCertifiable Points: 5790 More actions · Answer 2

I'm interested in why the question asks for the result from

SELECT
*
FROM dbo.UserConfig AS uc

rather than

SELECT
*
FROM dbo.UserConfig

Personally, I can't understand pointless aliasing.

Budd Hall of Fame Points: 3772 More actions · Answer 3

I curious as to what is the QOD for Oct 12 ?? OH Wait there it is.. 🙂
But how did that happen ?

Shayn Thomas SSCertifiable Points: 5863 More actions · Answer 4

nice question

---------------------------------------------------------------------------------------
The more you know, the more you know that you dont know

Steve Jones - SSC Editor SSC Guru Points: 734434 More actions · Answer 5

edwardwill - Tuesday, September 25, 2018 5:19 AM
I'm interested in why the question asks for the result from
SELECT
*
FROM dbo.UserConfig AS uc
rather than
SELECT
*
FROM dbo.UserConfig
Personally, I can't understand pointless aliasing.

Auto formatting. Prompt did it, and I like the config because if I modify this query, I already have an alias. I would never type this myself.

Steve Jones - SSC Editor SSC Guru Points: 734434 More actions · Answer 6

Likely an edit and a poor query caused the questions to get ordered strangely.