Statement level is the lowest level of granularity to fail or succeed upon. If you have in your example 100 records in table A to update based upon some logic (e.g. from another table, from a custom ...
As I've said on numerous occasions (and summed up here), speeding up business applications comes down to reducing the number of trips to the database and optimizing your server-side data access once ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results