September 10, 2018 at 8:19 pm
Comments posted to this topic are about the item Adding a row to a column set
September 10, 2018 at 11:31 pm
Nice question, thanks, Steve
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
September 11, 2018 at 12:37 am
Shouldn't the query read 'WHERE uc.UserID = 8'?
September 11, 2018 at 12:43 am
ildjarn.is.dead - Tuesday, September 11, 2018 12:37 AMShouldn't the query read 'WHERE uc.UserID = 8'?
That thought did occur to me as well.
It is still a good question, despite that.....
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
September 11, 2018 at 1:02 am
Stewart "Arturius" Campbell - Tuesday, September 11, 2018 12:43 AMildjarn.is.dead - Tuesday, September 11, 2018 12:37 AMShouldn't the query read 'WHERE uc.UserID = 8'?That thought did occur to me as well.
It is still a good question, despite that.....
How can it be a good question if it's a terrible question?
September 11, 2018 at 1:14 am
September 11, 2018 at 1:33 am
Carlo Romagnano - Tuesday, September 11, 2018 1:14 AMI've got it right, but the first and second answer seems to be equal!
Can someone clearyfy me?
The three sparse columns aren't returned, so 'all columns' isn't correct.
September 11, 2018 at 1:46 am
Thanks Steve,
I had no idea about Column Sets before today, so your question has done exactly what it should - expand my knowledge. Perfect.
Andy
September 11, 2018 at 2:20 am
Queries as written return no data whatsoever, so none of the answers is correct, surely?
September 11, 2018 at 2:48 am
Giles Sutcliffe - Tuesday, September 11, 2018 2:20 AMQueries as written return no data whatsoever, so none of the answers is correct, surely?
That's the option I was looking for.
September 11, 2018 at 2:55 am
Giles Sutcliffe - Tuesday, September 11, 2018 2:20 AMQueries as written return no data whatsoever, so none of the answers is correct, surely?
You aren't correct! The query returns an empty resultset with the columns and types defined in the first answer.
September 11, 2018 at 3:09 am
Carlo Romagnano - Tuesday, September 11, 2018 2:55 AMGiles Sutcliffe - Tuesday, September 11, 2018 2:20 AMQueries as written return no data whatsoever, so none of the answers is correct, surely?You aren't correct! The query returns an empty resultset with the columns and types defined in the first answer.
Not on my box it didn't!
September 11, 2018 at 3:14 am
Carlo Romagnano - Tuesday, September 11, 2018 2:55 AMGiles Sutcliffe - Tuesday, September 11, 2018 2:20 AMQueries as written return no data whatsoever, so none of the answers is correct, surely?You aren't correct! The query returns an empty resultset with the columns and types defined in the first answer.
The UserConfigKey, the UserID, and the Options column with 3 XML nodes.
The options column contains nothing. Option 1 says it contains 3 XML nodes. None of the answers is correct.
September 11, 2018 at 5:19 am
Since you're filtering on an identity column which would only have the value 1, why would any data be returned?
September 11, 2018 at 5:49 am
Actually no rows are returned. I guessed the first answer correctly. The WHERE clause needs to be changed.
Viewing 15 posts - 1 through 15 (of 28 total)
You must be logged in to reply to this topic. Login to reply