Hugo Kornelis (9/25/2012)

---

A good question; thanks!

However, I did find myself staring at the wording for a bit before answering - and hoping that my interpretation was the correct one. The term "failing" can be ambiguous. Some people might argue that "failing" also includes running without error but not rolling back changes on a rollback. And I even considered the possibility that the question was phrased by a non-native speaker who intended to ask which code fragments would have a permanent effect (e.g. the rollback would not affect the DDL statement).

Maybe a better way to phrase this would have been to ask "which fragments run without generating an error".

PS: The above is not meant to criticize, but to help Lokesh and other question authors think about possible ambiguity when submitting future QotD's.