I have a problem how to perfectly handle the conflict in update data.

If I need to put IF TABLEUPDATE() statement expicitly in each updating to detect update failure??

What is best strategy to handle Error?

Can anyone give me a guide or any reading meterial will help.

Thank in advance.