title: SQL Server 2005 - Add Milliseconds column onto DateTime column
body: <p>How do i combine 2 column using SQL server 2005 ?</p>
  
  <p>Problem is that The DateTime is stored in 1 column and the milliseconds is stored in another column.</p>
  
  <p>I want to add the Milliseconds onto DateTime column to give it a more accurate DateTime.</p>
  
  <p>I need to use this DateTime to query record accurate to milliseconds.</p>
  
  <p>Any idea?</p>
  
  <p>I need to replace DateTime with the added values.</p>
  
  <pre><code>SELECT * 
  FROM TABLENAME 
  WHERE [DateTime] &gt;= '2011-04-12 12:00:00 AM'
  AND [DateTime] &lt;= '2011-05-25 3:35:04 AM'
  </code></pre>
  
  <p>and run the query.</p>