Post reply

STUFF - 1

  • November 24, 2012 at 2:39 am

    #1561965

    Nice Stuff.

    T-SQL is Great

  • November 24, 2012 at 2:47 am

    #1561966

    Nice question - and a reminder to me to use STUFF more often.

    I don't understand why the explanation worries about the result length. . I agree with John Arnott's comments above about this. String functions either do or don't have a length parameter, and the ones that don't have a resulting length that can be any valid length (except MAX, unless a parameter of the function is declared with length MAX). Why should anyone expect STUFF to behave differently from + in this respect?

    Tom

  • November 26, 2012 at 12:41 am

    #1562084

    nice question for the week..

    +1 🙂

    learn about STUFF today

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • November 26, 2012 at 5:37 am

    #1562170

    Thanks for the STUFF question.

  • November 26, 2012 at 10:47 am

    #1562315

    Nice question and I learned STUFF.

    Aigle de Guerre!

  • November 29, 2012 at 8:34 am

    #1563832

    Simple but tricky One.

  • December 3, 2012 at 6:45 am

    #1564854

    really very good question. i answered it in hurry, but after i check it again and got the reason behind the answer.

    thanks

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

  • December 24, 2012 at 6:06 pm

    #1571382

    When the question says "I then execute (second SELECT statement) that implies to me that you execute ONLY that SELECt statement, which would give an error, as the variable is not defined.

    I am taking the question literally. Is that wrong?

    D

Viewing 8 posts - 16 through 22 (of 22 total)

You must be logged in to reply to this topic. Login to reply