title: How to update primary key
body: <p>Here is my problem - I have 2 tables:</p>
  <ol>
  <li>WORKER, with columns <code>|ID|OTHER_STAF|</code> , where ID is primary key</li>
  <li>FIRM, with columns <code>|FPK|ID|SOMETHING_ELSE|</code> , where combination FPK and ID make primary key, and also ID is a foreign key referenced to WORKER.ID (not null, and must have same value as in WORKER).</li>
  </ol>
  <p>I want to make stored procedure <code>UPDATE_ID_WORKER</code>, where I would like to change the value of specific ID in WORKER, and also in all instances of specific value of ID in FIRM.</p>