title: SQL Server : cannot update column in table
body: <p>I cannot work out why my column is not being updated.</p>
  
  <p>I have added a new column to an existing table as follows:</p>
  
  <pre><code>ALTER TABLE dbname..tablename 
    ADD RejectedCode [varchar](5) NULL
  </code></pre>
  
  <p>When I run the query below:</p>
  
  <pre><code>UPDATE dbname..tablename 
  SET RejectedCode = 'OTHER',
      Notes = 'DEBUG'
  WHERE RecordID = 12345
  </code></pre>
  
  <p>it says:</p>
  
  <pre><code>(1 row(s) affected)
  </code></pre>
  
  <p>I check the respective record and I can see the <code>Notes</code> column updated, but the new column still displays NULL and I don't get any error message. </p>
  
  <p>What am I doing wrong?  Many thanks for help.</p>