Viewing 15 posts - 46 through 60 (of 656 total)
Where in the question did it state that this was SQL2016?
Even with the new option, why are the tooltip and properties answers incorrect? They're just presenting different views of the...
December 14, 2016 at 1:59 am
funbi (11/17/2016)
It's a QotD on a forum. The table has 7 rows. Efficiency is not a factor in this instance. My sql was not incorrect - it brought back the...
November 18, 2016 at 5:43 am
I'm assuming there was a typo in one of the options and it was meant to have a character before the initial bracket, so the correct answer would have returned...
November 17, 2016 at 3:44 am
The answer is right, but the explanation is wrong, as it says the answer is 0,1,2,NULL,NULL
If that had been one of the options I might have got it wrong as...
November 15, 2016 at 1:50 am
Took me a while to work this out, as I thought the lower-case l for the first column was a number 1. Would have been better with different column names!
After...
September 22, 2016 at 2:13 am
July 7, 2016 at 2:06 am
Aaron N. Cutshall (6/6/2016)
However, I do understand the intent of the QotD however it was presented.
What was that intent, to encourage sloppy coding?
June 6, 2016 at 8:14 am
I knew what was intended but the correct answer surely should be "No, Never".
The semi-colon is not required to begin the CTE; it is required to terminate the previous...
June 3, 2016 at 12:51 am
I guessed the first option (about the = sign) as there was obviously something wrong with the question (the SQL will run fine) so I guessed that the typo was...
June 1, 2016 at 1:51 am
Had to resort to running some SQL for this one, as I don't carry the ascii table in my head 😉
May 11, 2016 at 3:03 am
The correct answer is "there is no vardecimal datatype".
It is not a different data type, it is a different way of physically storing the decimal data type.
It's also deprecated in...
May 10, 2016 at 2:03 am
This is a disgrace I demand you give me the points that have been stolen from me in fact I want double points as compensation for the distress caused I'm...
May 6, 2016 at 1:11 am
I didn't know, so chose "I don't know", but was told that apparently I did know after all.
Obviously I'm cleverer than I thought.
April 28, 2016 at 3:40 am
Although the documentation states that conversion of an int value that is too long will give an error if converting to nvarchar, but * if converting to varchar, it does...
April 21, 2016 at 2:17 am
Viewing 15 posts - 46 through 60 (of 656 total)