Viewing 15 posts - 121 through 135 (of 191 total)
I do agree the question would have been more instructive without the "gotcha" but I can't argue about the answer.
EDIT: And after reading Thomas Abraham's response, I take back my...
September 27, 2011 at 5:40 am
I'm hoping by this afternoon I will have read the explanation enough times to understand it, because I sure as heck don't at this hour of the morning! 😉
ron
September 13, 2011 at 5:52 am
Silly me, assuming the blatantly obvious answer couldn't possibly be correct.
ron
August 23, 2011 at 3:15 pm
That was an excellent question, and not at all a "trick question"... very nice!
ron
August 5, 2011 at 7:41 am
Carlo Romagnano (8/3/2011)
August 3, 2011 at 5:41 am
Thomas Abraham (8/1/2011)
Just curious - what situations require replacement of CHAR(0)? How does it end up in your data? Thanks.
In my particular case, it was found in some Access data...
August 2, 2011 at 5:49 am
bitbucket-25253 (7/31/2011)
Even stranger, used NVARCHAR(max) and the behavior is completely different.
I noticed that too, and it inspired me to search my code for any varchars and change them to nvarchars,...
July 31, 2011 at 7:44 am
While you guys argue over the correct answer, I'm going to spend the morning learning what "re-entrant" means. 😀
ron
June 28, 2011 at 5:01 am
Mike Byrd (6/21/2011)
Makes it even more interesting if you add following:insert into @test-2 values ( NULL )
Answer is still 6.
Because aggregate functions ignore NULLs, right?
Good question today, thanks....
June 21, 2011 at 7:25 am
I may not have learned anything directly from the question; but on the plus side, in researching the question I did learn all about sexy prime triplets.
>>>No, I'm not kidding!<<<
ron
April 1, 2011 at 5:52 am
paul s-306273 (3/16/2011)
I don't really see the value of this question...
The nearly 40% of respondents who got it wrong learned something today. That alone seems valuable enough to me,...
March 16, 2011 at 5:39 am
I haven't had great experiences with telecommuting. I know for sure it's not for me; I need that clear separation between work time and home time or else I'm...
February 23, 2011 at 5:34 am
I understood the question, and I thought it was a good one. I had honestly never considered whether or not the INSERTED table could be updated. I thought...
January 10, 2011 at 5:52 am
Hugo Kornelis (1/4/2011)
January 4, 2011 at 5:44 am
Well that's what I get for second-guessing myself. It seemed like such an easy question, the obvious answer couldn't possibly have been right. Guess that'll teach me! 😉
Ron
December 29, 2010 at 5:40 am
Viewing 15 posts - 121 through 135 (of 191 total)