title: SQL Server : set a default value for Insert Into query when parameter is null
body: <p>I'm trying to do an insert query like follow:</p>
  
  <pre><code>Insert Into table1 (column1, column2)
  Values (#value1#, #value2#)
  </code></pre>
  
  <p>But let's say, I want to default column2 to <code>2/19/2013</code> when the parameter <code>#value2#</code> is null. How would I achieve that? </p>
  
  <p>I'm using Ibatis framework, and the insert statement is in a XML file, which is used in a db file that is called from the controller.</p>