Or set RaiseError, which would make it die automatically in case of error...
In reply to Re^4: UPDATE not working with MS SQL Server by Eliya in thread UPDATE not working with MS SQL Server by Perobl