I have a table with a Value column and a Status column.
What is the simplest and most effective way to enforce the following? The idea is that money values are entered into the database and then someone says "Final" and after that I need to guarantee no changes because a billing process begins.
A trigger is the best way to enforce this.