Viewing 15 posts - 1 through 15 (of 264 total)
I didn't really care so just guessed and got it right.
Most developers will only ever use one method. That may depend on in-house standards but I'd recommend that used...
September 2, 2015 at 2:13 am
Nice to see a "real world" question on here. At the moment roughly 25% of respondents have gone for the answer which would make any US record with a missing...
August 28, 2015 at 2:06 am
Though I was looking for a "none of the above" answer to "which of these queries will do this",...
August 3, 2015 at 2:31 am
Nice question - I did not see that coming!
July 29, 2015 at 2:23 am
Also a good illustration of why NOT IN can be very risky. Using NOT EXISTS instead gives the result that would probably be intended in this scenario:
FROM #tmpNewValue new
July 28, 2015 at 2:55 am
edwardwill (7/24/2015)Another terrible question. Only 16 words in the question - you could have extended it to 18 by adding "Express Edition".
This was the question titled "Max DB Size...
July 24, 2015 at 3:05 am
Koen Verbeeck (7/16/2015)Hmmm, people have actually selected "drop the database". :w00t:
Koen Verbeeck (7/16/2015)
That would certainly achieve the stated goal.
Plus some other ones.......
July 16, 2015 at 2:25 am
Well, the query returned the two table names and the name of the foreign key.
What it didn;t do was show the relationship (i.e. columns) between the two.
July 1, 2015 at 9:28 am
Unusually I thought it was quite an easy question and that two points was a bit generous. But then I saw that more people were getting it wrong than right...
June 16, 2015 at 3:10 am
Only an easy question if you know all of the SQL Server error codes. Otherwise the only way to get it right is to cheat and run the code.
June 11, 2015 at 2:06 am
Just out of interest is there a rule or convention on what these symbols are called? Strictly speaking,
' is an apostrophe, and
" is a quote.
Confusion sets in when terms...
May 27, 2015 at 8:11 am
Hany Helmy (5/26/2015)OK, the author should have (like all other QotD) mention to select 2 answers, still it`s a very good question.Thanx.
Hany Helmy (5/26/2015)
The question featured checkboxes rather than radio buttons and...
May 26, 2015 at 2:25 am
We've just elected the Ragged Right to run our country for another five years.
May 12, 2015 at 3:08 am
There's a good article at Simple Talk[/url] which mentions the limit and the reason.
Where it says "116 characters or less" it means "116 characters or fewer" 😉
April 10, 2015 at 2:43 am
It should have been possible to attempt an answer without just running the code. And, given the title of the question, it should have been clear that the "tmp" error...
April 8, 2015 at 2:51 am