title: SQL Server : fetching records between two dates?
body: <p>In SQL I write a <code>SELECT</code> statement to fetch data between two dates, using <code>between and</code> </p>
  
  <p>Ex:</p>
  
  <pre><code>select * 
  from xxx 
  where dates between '2012-10-26' and '2012-10-27'
  </code></pre>
  
  <p>But the rows returned are for 26th only, not 26th and 27th.</p>
  
  <p>Can you help me? Thank you.</p>