title: Inserting value to all rows in one column
body: <p>I am using VB.net 2013 and SQL Server 2012. I have a table <code>tblEmployeeInfo</code> with two columns, <code>EmployeeName</code> and <code>Date</code>:</p>
  
  <pre><code>EmployeeName   Date
  --------------------
  Jay            Null
  Mike           Null
  Paul           Null
  </code></pre>
  
  <p>When I input a date value in <code>Textbox1</code> like <code>3/20/2017</code>, it would insert that value into all rows into column <code>Date</code>.</p>
  
  <pre><code>EmployeeName   Date
  -------------------------
  Jay            3/20/2017
  Mike           3/20/2017
  Paul           3/20/2017
  </code></pre>
  
  <p>Please anyone help me out. Still no idea how to code using VB.net. My idea just to insert only using <code>WHERE</code> clause. But how to insert at once? Thank you guys.</p>