title: Default getdate for Insert date
body: <p>I have a table called sample and it has a column called [__INSERT_DATE] which is null. Now I want to alter the column with default as <code>getdate()</code>. When I tried the following it gave me an error.</p>
  
  <pre><code>ALTER TABLE sample
  ALTER COLUMN [__INSERT_DATE] [datetime] DEFAULT (getdate()) NULL)
  </code></pre>
  
  <p>Can anyone tell me what the problem is?</p>