• Vladan - Friday, August 10, 2018 5:32 AM

    sipas - Friday, August 10, 2018 3:41 AM

    Not sure about this one - I thought that UPDATE() returned TRUE if an attempt was made to update the column, regardless of whether the update was successful. Chose the right answer because it was the only one that had a Boolean value, but is " true for changes or false for no changes" correct?

    I think that if update is unsuccessful, trigger does not fire.

    I thought UPDATE() was meant to tell you if an attempt was made to update the column, so it would be TRUE even if the update is unsuccessful - not sure though...