• I'm not trying to be difficult here but I have to disagree with you bitbucket.

    If I write an update statement i get a response along the lines of

    23 row(s) affected

    Your correct answer implies that what we should expect is

    23 row(s) affected and 34 row(s) unaffected

    which isn't the case. If a row is untouched, as row 1 is, the fact it was untouched is implicit and needs no explanation as such. I appreciate it was an error that has now been corrected but trying to defend it by suggesting we missed a subtlty of the question rather than admitting that it was wrong is missing the objective of the QotW as much as you suggest we are.

    Paul