title: How to add column value in SQL Server 2008 r2?
body: <p>I created a table called <code>Dummy</code> with 4 columns: <code>Date, Year, Student_Names, Subject</code>. </p>
  
  <p>After a few days I need to add one more column name called <code>Marks</code>.</p>
  
  <p>I know how to add column <code>Marks</code> by using the SQL query, I am using the query below:</p>
  
  <pre><code>Alter Table Dummy 
  add Mark varchar(30)
  </code></pre>
  
  <p>After I add the column, all values are NULL, I need some value in the place of NULL. </p>
  
  <p>How do I add those values? Values are mentioned in an Excel file.</p>