You can use OUTPUT Clause something like this
UPDATE tablename SET invoice = 10 OUTPUT deleted.invoice --you may try to put condition here
and you may use Triggers.
I hope this is helpful.
Please Mark it as Answered if it answered your question
OR mark it as Helpful if it help you to solve your problem
Elmozamil Elamir Hamid
MCTS: SQL Server Administration/Development
simply add a condition to your query
set [column] = [new_column value]
where [column] < [new_column value];
But if the update is automatically you can add a TRIGGER "TRIGGER_NAME" BEFORE UPDATE ON "TABLE_NAME"
and do the update if :NEW.value > [column] ....
- Edited by Hala Developer Thursday, June 28, 2012 9:46 AM more details