• kapil_kk (4/18/2013)


    oopes,

    I think I have misunderstood the way to execute the given query...

    After seeing comments First Attempts, second, third I executed one by one those insert query and forget about the GO batch separator... and I was thinking it was so easy question and count will give 3 but i was wrong and lost the points... 🙁

    I think most of the think count value as 3 and executed in same fashion that I executed that's why load towards incorrect answer is more than correct answer...

    Result of 3 will be given, if GO exists after this insert

    -- Insert attempt #2

    INSERT INTO dbo.Test (PrimKey, ValueCol)

    VALUES (2, -2);

    GO

    Regards

    IgorMi

    Igor Micev,My blog: www.igormicev.com