Ars Technica

SQL Server 2005: Continue statement on error (Resume on Next)

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.