Hugo Kornelis (4/19/2013)
kapil_kk (4/18/2013)
oopes,I think I have misunderstood the way to execute the given query...
Oohhh, I am so sorry that the comments in the code made you misunderstand the question. I added them to be able to refer to them in the explanation, not for any other reason, and I'm sorry if that caused people to come to wrong conclusions.
The next question in this series is scheduled for next week. Since it's already scheduled for publication, I cannot change it, or even see it anymore. That's how this site works. If my memory is not playing tricks on me, that question, too, will have similar comments. So please don't fall for that again!
Thanks Hugo, question was good and I have gained something from this question that how a rollback from a trigger affects a batch...:-)
For the next question I will keep comments things in my mind 😛
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/