You are right the hiring managers can be idiots. This story reminded me of an interview I took just after graduating from college. I was asked a question by 1 member...
What you want to do is use separate statements to update each of the tables but enclose the pair of statements within Begin Transaction and Commit Transaction. If an error...