I'm not sure what you mean by "settings", but one method you could use to make the update statement "fail" is to add a constraint:

ALTER TABLE #a WITH CHECK

ADD CONSTRAINT _check CHECK (id < 100) ;

Not sure, if this is what you're lokking for though...

As a side note: your statement I don't care if the the val=100 or 200 sounds scary to me...