title: SQL update a table with a foreign key
body: <p>I have a categories table, which one of the fields serves as the foreign key for a sub-categories table.  One field that serves as part of the primary key for each table is the language id.  I need to update these in both tables.  Basically, wherever the language id = x in both tables, I need to set it to y.  </p>
  
  <p>When I try to do an update on either table, I get a 'The UPDATE statement conflicted with the REFERENCE constraint..' which refers to the foreign key constraint.  </p>
  
  <p>How can I update the language field on both of these tables?</p>