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 allow the SQL statement to continue.

Want faster SQL queries? Here are nine best practices for writing SQL queries that work like a charm (or at least, like they should).