Forum Replies Created

Viewing 15 posts - 91 through 105 (of 256 total)

  • RE: Table Alias

    Hugo Kornelis (5/2/2013)


    Good question, though I'm surprised that, apparently, people are doing this wrong. Since you'll be rewarded by an error message when you try, I don't understand how people...

  • RE: REPLICATE - 1

    Thanks for question.

  • RE: Table Variable

    Lokesh Vij (4/29/2013)


    Was keeping busy with my Master's exams. Finally they are over 😀

    So now its party time 😀

  • RE: Table Variable

    kapil_kk (4/29/2013)


    Welcome back Lokesh, after a long time I see you man :-P;-)

    me too !!! :-):-):-)

  • RE: Table Variable

    Good question with important information.

  • RE: Create Table

    Hugo Kornelis (4/26/2013)


    I first focused on the reference to a unique constraint rather than the primary key, thinking that was the issue of the question. I almost got it wrong...

  • RE: Create Table

    Kapil, very good question. 🙂

  • RE: Triggers 2

    Great question hugo. Last week i asked a question related to this kind of scenario. 🙂

  • RE: Nested triggers 1

    Very good question. Till all the QOD, this question take more time. You need to look and dry run every t-sql code carefully. Finally i am happy, i got point...

  • RE: Handling NULL

    Good question kapil.

    I feel that this question contains it's answer in itself. Why i think so? Let me tell you.

    In question, you told that you need the output like:-...

  • RE: Triggers 1

    Hugo, Question title is "Triggers 1", so everybody look at trigger (even be also). But trick was in "GO"

    I think question title should be "GO". 🙂

  • RE: Triggers 1

    Very good question hugo 🙂

    In the starting of question, i come with answer 3. But suddenly i check "go", and game changed. 😀

    Good question with good trick.

  • RE: Sum and Count

    kapil_kk (4/17/2013)


    Nice question... learn something new today.. 🙂

    But can anyone plz explain me about the SUM part which is returning 12, I am not clear with this section :w00t:

    Kapil, Cross...

  • RE: Row Constructor

    Really a very good question. Thanks

    🙂

  • RE: COUNT() Function

    yogyogi97 (4/15/2013)

    COUNT(convert(int,NULL)) - It will give count as 0 always. Don't know why it is giving 0 count however COUNT() function counts NULL values also.

    Please go through below select...

Viewing 15 posts - 91 through 105 (of 256 total)