Any column that is not modified retains its original values, except in certain queries using the CASE expression. See CASE expression for a description of CASE expressions. To add, drop, or modify a ...

For example, let's say I'm updating 100 rows in a table. I'd like to know that a NULL is going to be inserted into a non-nullable field on one row via RAISEERROR, skip that row's update, and then ...