Forum Replies Created

Viewing 15 posts - 91 through 105 (of 257 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...

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

    May 2, 2013 at 1:33 am

    #1611810

  • RE: REPLICATE - 1

    Thanks for question.

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

    April 30, 2013 at 11:22 pm

    #1611464

  • 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 😀

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

    April 29, 2013 at 11:48 pm

    #1611109

  • RE: Table Variable

    kapil_kk (4/29/2013)

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

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

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

    April 29, 2013 at 11:24 pm

    #1611103

  • RE: Table Variable

    Good question with important information.

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

    April 29, 2013 at 11:24 pm

    #1611102

  • 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...

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

    April 26, 2013 at 4:02 am

    #1610279

  • RE: Create Table

    Kapil, very good question. 🙂

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

    April 25, 2013 at 11:14 pm

    #1610199

  • RE: Triggers 2

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

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

    April 24, 2013 at 11:29 pm

    #1609784

  • 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...

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

    April 22, 2013 at 11:29 pm

    #1608940

  • 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:-...

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

    April 21, 2013 at 11:34 pm

    #1608585

  • 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". 🙂

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

    April 19, 2013 at 1:22 am

    #1608093

  • 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.

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

    April 19, 2013 at 12:18 am

    #1608083

  • 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...

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

    April 17, 2013 at 11:31 pm

    #1607533

  • RE: Row Constructor

    Really a very good question. Thanks

    🙂

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

    April 16, 2013 at 11:06 pm

    #1607115

  • 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...

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

    April 15, 2013 at 11:31 pm

    #1606684

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