title: how to add today date as default value in sql server
body: <p>in sql server. my <code>database</code> name RequestInfo, I have a table name RequestedDate, which have data type is <code>datetime</code>. now i want when ever the value of  other columns of table is inserted, then automatically in the RequestedDate <code>column</code>, today date should inserted. 
  i am using this <code>query</code> but it shows no today in built function.</p>
  
  <pre><code>alter table RequestInfo add default Today() for RequestedDate
  </code></pre>