title: How to update table and add column value in SQL Server?
body: <p>How to add column and column value this table? (this table is update and adding)</p>
  
  <p>Database A:</p>
  
  <p>Table Student</p>
  
  <pre><code>ID  Name    Age
  ----------------
  1   John    24
  2   Albert  23
  3   Kelvin  24
  4   Carol   25
  </code></pre>
  
  <p>after update:</p>
  
  <pre><code>ID  Name    Age    SchoolNo
  ---------------------------
  1   John    24       1245
  2   Albert  23       1245
  3   Kelvin  24       1245
  4   Carol   25       1245
  </code></pre>