A check constraint will run to ensure that the database contents are invariant (meet the check constraint). So if two update statements are executed the check constraint is executed twice, once after each update.
A check constraint will run to ensure that the database contents are invariant (meet the check constraint). So if two update statements are executed the check constraint is executed twice, once after each update.