title: Automatic Adding Current DateTime In TableField
body: <p>I am using <strong>SQL SERVER 2005</strong> and i am also newbie to <strong>SQL SERVER</strong></p>
  
  <p>now i need to know that <strong>is there any way</strong> or any <strong>technique</strong> in SQL SERVER 2005</p>
  
  <p>such that <strong>as soon as i add new record in table</strong> then <strong>current date-time should be added in to any given field of table</strong>.</p>
  
  <p><strong>Example:</strong></p>
  
  <p>Suppose i have <strong><code>CUSTOMER</code></strong> table 
  and it has fields say <strong>CustomerID,CustomerName</strong>,....,<strong>DateTime</strong>.
  now whenever <strong>new customer added in this table</strong> then <strong>current date-time</strong> should be <strong>automatically</strong> added in to <strong><code>DateTime</code></strong> Field of <strong><code>CUSTOMER</code></strong> table.</p>