Forum Replies Created

Viewing 15 posts - 31 through 45 (of 90 total)

  • RE: That case filter

    Steve Jones - SSC Editor (7/20/2011)

    cengland0 (7/20/2011)

    BenWard (7/20/2011)

    From my PoV the QotD is there, not as a status symbol or as bragging points but rather to help us do our...

    July 20, 2011 at 10:48 am

    #1355861

  • RE: That case filter

    Carlo Romagnano (7/20/2011)

    But if that is not the case then the answer should be "There is NO query returning rows."

    I agree with you!

    Ditto.

    July 20, 2011 at 10:33 am

    #1355847

  • RE: Here's a Reason to Document

    Never used (or even heard of) Krugle.

    At my Firm, we've had a few methods over the years for documenting our work (Folio Views, anyone? :-)). For those of us...

    July 13, 2011 at 7:42 am

    #1352158

  • RE: July 4

    Koen Verbeeck (7/3/2011)

    Thank god for Will Smith and aliens 😉 😀 :hehe:

    And Will's GF...and Judd Hirsch (still see him weekly in "Numb3rs" reruns)...and.... Now if someone can tell me...

    July 5, 2011 at 10:32 am

    #1348442

  • RE: Connection Problems

    Ronald H (2/7/2011)

    Exactly a scenario that happens in our environments. Thanks for the question!

    Ditto x 2 :-).

    Re the question's phrasing and its choices: since its "you" can successfully connect to...

    February 7, 2011 at 11:08 am

    #1283321

  • RE: T-SQL

    Sean Lange (12/15/2010)

    Good question. Don't worry about the people who are complaining about the question. There are some people who will complain no matter how clear the question is. Given...

    December 15, 2010 at 9:48 am

    #1262982

  • RE: COLLATION

    cengland0 (11/3/2010)

    SanDroid (11/3/2010)

    Nice question.

    I learned something, there were no errors or typos with the answer, and the reference data supported the documentation.

    The only negative comment I have is...

    November 3, 2010 at 9:39 am

    #1246108

  • RE: SET ROWCOUNT and table variable

    mccork (8/25/2010)

    The answer was almost obvious from the "do not run it on production server" recommendation.

    <<snip>>

    Agreed (and frankly, I wouldn't have chosen the right answer otherwise :-))!

    August 27, 2010 at 10:18 am

    #1213085

  • RE: Round up or down IV

    Hugo Kornelis (8/24/2010)

    Nope, I already did that last week! http://www.sqlservercentral.com/questions/T-SQL/70325/[/url]

    Sorry -- I was away from computers last week and missed it (but I guess I can now look at it...

    August 24, 2010 at 9:00 am

    #1211083

  • RE: Round up or down IV

    paul.knibbs (8/24/2010)

    Didn't know ROUND() could do this, but once I looked it up in Books Online it seemed fairly straightforward--I learned something today, which is always nice!

    Get ready for a...

    August 24, 2010 at 8:40 am

    #1211060

  • RE: Round up or down I

    Oleg Netchaev (8/3/2010)

    mtillman-921105 (8/3/2010)

    I think that this "feature" should be changed. Just because two numbers are integers, why assume the answer should also be an integer? :angry:

    I would...

    August 3, 2010 at 10:54 am

    #1201674

  • RE: More fun with ISNUMERIC()

    paul.knibbs (7/5/2010)

    I was expecting an answer of 14 (numbers 0-9, +, -, . and $), but of course that wasn't an option, so I had to go and run the...

    July 6, 2010 at 10:13 am

    #1189182

  • RE: LIKE

    OCTom (6/24/2010)

    Sounds like an interview question. :hehe:

    At least as the first part of a possible two-parter ("So you think it's possible? OK, please give me an example....") :-).

    June 24, 2010 at 8:10 am

    #1184522

  • RE: T-SQL SQL 2008

    Lynn Pettis (6/21/2010)

    I got it right, but I had to research BOL to figure out some of the operators.

    Sounds like I'm in the minority in having a background in C...

    June 21, 2010 at 11:19 am

    #1182883

  • RE: LEN()

    UMG Developer (6/14/2010)

    ...I probably would have had the second option be 5, 2, 3...

    Agreed. I think 5,2,5 makes no sense and should influence a decision in favor of 5,2,2.

    June 15, 2010 at 8:13 am

    #1180446

Viewing 15 posts - 31 through 45 (of 90 total)