title: String or binary data would be truncated in sql server 2014
body: <p>Here is my table in SQL Server:</p>
  
  <pre><code>CREATE TABLE [dbo].[contacts]
  (
      [contact_id] [int] IDENTITY(1,1) NOT NULL,
      [user_id] [int] NOT NULL,
      [c_name] [varchar](100) NOT NULL,
      [c_number] [varchar](50) NOT NULL,
      [c_mail] [varchar](30) NOT NULL,
      [c_address] [varchar](30) NOT NULL,
      [c_date_added] [date] NOT NULL
  );
  </code></pre>
  
  <p>and insert query</p>
  
  <pre><code>INSERT INTO contacts (user_id, c_name, c_number, c_mail, c_address, c_date_added) 
  VALUES (1, 'Aman', '9855', 'aman', 'Gidd', '2014');
  </code></pre>
  
  <p>I am getting this error.</p>
  
  <blockquote>
    <p>String or binary data would be truncated. The statement has been terminated.</p>
  </blockquote>
  
  <p>Please help.</p>