title: Append values to a column value in database
body: <p>I want to append a large string values with the existing values of a column value in DB. this column is set as <code>nvarchar(MAX)</code>. But when I am trying, only first few parts of new string is appending with old value. Others are not appending. Please suggest . </p>
  
  <pre><code>string initial_result ="xxxxxx";//reading values from db column and assigning to string
  string final_result="yyyyyyyyyy";//lengthier one
  SqlCommand cmd71 = new SqlCommand("update details set  result='" + initial_result + "'+'"+finalresult+"' where student_id ='11' ", con7);
  cmd71.ExecuteNonQuery();
  </code></pre>