Viewing 15 posts - 6,931 through 6,945 (of 7,483 total)
Adam Machanic (4/26/2010)
Tom.Thomson (4/26/2010)
Tom
April 26, 2010 at 9:24 pm
Well, it was pretty obvious what the author thought was the first rule, so I got my point. But I believe the right answer isn't actually in the list...
Tom
April 26, 2010 at 8:31 pm
I think the suggested answer is the wrong way to do it. The sensible thing to do is either use a thread and communicate by messaging (have that thread...
Tom
April 26, 2010 at 8:20 pm
Paul White NZ (4/26/2010)
+1. I didn't even bother to Google - I waited for the correct answer to be mailed to me today 😉
I was surprised by the number...
Tom
April 26, 2010 at 7:33 pm
A brilliant article. Keep it up!
Tom
April 26, 2010 at 7:08 pm
Jeff Moden (4/24/2010)
Tom
April 26, 2010 at 6:49 pm
Adam Machanic (4/26/2010)
Tom
April 26, 2010 at 5:18 pm
Amit-695544 (4/4/2008)
hi friends !!I am sorry but is this a bug, MS's overesmartness of type conversion or somthing logical thing. :w00t:
Please be clear.
Thanks .
My take is that MS decided to...
Tom
April 25, 2010 at 2:25 pm
Adam Machanic (2/4/2005)
Tom
April 25, 2010 at 2:02 pm
Matt Marston (2/4/2005)
<FONT color=#111111>Wouldn't the correct answer be </FONT><FONT color=#00008b>'This is an interesting table ' </FONT><FONT color=#111111>(with an extra space on the end)? </FONT>
Yes.
Tom
April 25, 2010 at 2:00 pm
Adam Machanic (12/17/2004)
print convert(varchar(3), 0x697320) +
convert(varchar(5), 0x747279696E) +
convert(varchar(1), 0x67) +
convert(varchar(7), 0x20746F206D616B) +
convert(varchar(4), 0x65206869) +
convert(varchar(3), 0x6D7365) +
convert(varchar(8), 0x6C66207365656D20) +
convert(varchar(1),...
Tom
April 25, 2010 at 11:28 am
CirquedeSQLeil (12/13/2009)
Doh - version based question where the results change.SSMS 2005 and 2008 both gave me 3.4
Perhaps at the date the question was set it was reasonable to assume sql...
Tom
April 25, 2010 at 11:16 am
Steve Jones - Editor (11/18/2004)
Tom
April 25, 2010 at 10:34 am
Steve Jones - Editor (10/10/2009)
Comments posted to this topic are about the item <A HREF="/articles/books/67141/">SQL Server Stumpers, Vol.5</A>
Are vols 1 to 4 still around?
Tom
April 25, 2010 at 10:02 am
Steve Jones - Editor (11/16/2004)
Tom
April 25, 2010 at 9:34 am
Viewing 15 posts - 6,931 through 6,945 (of 7,483 total)