title: Update even though using constraints
body: <p>I'm trying to update a value (small spelling error) in the SQL Server 2014 database.</p>
  
  <p>I do like this:</p>
  
  <pre><code>update t_Table set funID = 'References' where funID = 'Referencies'
  </code></pre>
  
  <p>When doing this I get the error</p>
  
  <pre><code>The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_t_Table_Language_t_Table". The conflict occurred in database "db", table "dbo.t_Table".
  </code></pre>
  
  <p>If updating the foreign key, I get a similar error.</p>
  
  <p>Is there any way to update all values at the same time?
  I have a vague memory of someone showing a way to do this in management studio but I do not recall how.</p>