• muhammad.mazhar (5/27/2010)


    i chose the last answer, cause this is what happend to me. But my answer is wrong. I don't understand. what I'm missing here?

    Regards,

    Mazhar Karimi

    What you are missing is that the question was not "what happens if you run this code", but "what is the result of the SELECT statements". The error you do see is caused by the trigger.

    Or, another way to put it, you are missing that the point of these questions is to think about it, not to test your ability to copy/paste.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/