title: Insert current date into ASP SQL
body: <p>have a table with a transaction date in it. It is set as a timestamp and basically I want on creation of a new record that field automatically inserts the current date.  I am using visual studio 2010 and ASP.net SQL not sure how to go about it. Dont need SQL injection protection for this just a simple way of doing it. Any ideas?</p>
  
  <p>Mark</p>