Viewing 15 posts - 31 through 45 (of 656 total)
January 8, 2018 at 9:29 am
Quite interesting I suppose, though the URL in the explanation doesn't state what happens when there is a conflict between alias and position.
The main thing I'd want to know...
January 8, 2018 at 2:01 am
Presumably there's a mistake in the question requiring 2 answers and it is meant to be a single-answer question? The only possible answer if 2 are correct would be that...
December 14, 2017 at 2:08 am
if it helps:
Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64) Oct 28 2016 18:17:30 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2012 R2 Standard 6.3...
December 12, 2017 at 8:24 am
Can't say I'm a fan of trick questions (ie I got it wrong due to answering on the basis of the data returned not the column name). 😉
But given...
December 5, 2017 at 2:21 am
November 16, 2017 at 5:02 am
November 15, 2017 at 1:53 am
November 13, 2017 at 3:59 am
I'd forgotten that integer division truncates rather than rounds, so if 3.5 had been an option I'd have got it wrong.
The moral is, never rely on implicit conversions. I...
September 19, 2017 at 1:53 am
July 28, 2017 at 8:52 am
July 17, 2017 at 1:51 am
July 11, 2017 at 2:29 am
Presumably one of the last two options was supposed to be Two and Two, otherwise they are both the same and there's only one answer that has Two for the...
January 3, 2017 at 2:56 am
Viewing 15 posts - 31 through 45 (of 656 total)