Sometimes, but not always:
After an INSERT, UPDATE, or DELETE, check the value of @rowcount.
In an INSERT, @rowcount would normally be 1.
In every case, it depends on the code. If the plan is to delete exactly one record and @rowcount is not 1, then raise an error.
See Standardized RAISERROR Calls for more information and example code.