title: Can't update table in SQL Server
body: <p>I am using SQL Server and SSMS 2008. I am in the correct database.</p>
  
  <p>Sorry if this is obvious. I have the following table with no PK to start off with so I can easily make changes until the process works for me</p>
  
  <pre><code>CREATE TABLE Staging.Country_code 
  (
      Country varchar(200) NOT NULL,
      ISO_2 varchar(2) DEFAULT 'Not Available',
      ISO_3 varchar(3) DEFAULT 'Not Available',
      ISO_numeric int
  )
  GO
  </code></pre>
  
  <p>I successfully inserted the following:</p>
  
  <pre><code>INSERT INTO Staging.Country_code (Country, ISO_2, ISO_3, ISO_Numeric)
     SELECT Country, ISO_2, ISO_3, ISO_Numeric
     FROM RawStaging.Country_code
     WHERE Country IS NOT NULL
  GO
  </code></pre>
  
  <p>Now I want to insert other items into it:</p>
  
  <p>First I tried:</p>
  
  <pre><code>INSERT INTO Staging.Country_code (Country)
     SELECT DISTINCT 
        Staging.allYears.Country 
     FROM 
        Staging.allYears
     WHERE 
        Staging.allYears.Country NOT IN (SELECT DISTINCT Staging.Country_code.Country 
                                         FROM Staging.Country_code)
  GO
  </code></pre>
  
  <p>And got error:</p>
  
  <blockquote>
    <p>Msg 8152, Level 16, State 14, Line 1<br>
    String or binary data would be truncated. The statement has been terminated.</p>
  </blockquote>
  
  <p>Then I tried simply (among other things including trying to cast to <code>varchar(200)</code> a single text item to insert it into the <code>Country</code> column):</p>
  
  <pre><code>INSERT INTO Staging.Country_code (Country, ISO_2, ISO_3, ISO_numeric)
  VALUES ('Africa', 'Test', 'Test', 0);
  </code></pre>
  
  <p>And still get same error.</p>
  
  <p>I checked the data types on the table and they are still exactly as in the create statement.</p>
  
  <p>I am only an SQL beginner, I just cant see why this might not work. There is definitely data in the table I have selected the first import and it is still there. Nothing is referencing the table.</p>
  
  <p>Am I missing something really obvious?</p>