title: Why doesn't explicit COLLATE override database collation?
body: <p>I am on SQL Server 2008 R2 dev, server default collation is Cyrillic_General_CI_AS  </p>
  
  <p>Executing in SSMS<br>
      SELECT 'éÉâÂàÀëËçæà' COLLATE Latin1_General_CS_AS<br>
  or  </p>
  
  <pre><code>SELECT 'éÉâÂàÀëËçæà' COLLATE Latin1_General_CI_AI   
  </code></pre>
  
  <p>outputs </p>
  
  <ul>
  <li>eEaAaAeEc?a on(in ocntext of/use dbName) of database with default collation Cyrillic_General_CI_AS   </li>
  <li>éÉâÂàÀëËçæà on database with default collation Latin1_General_CI_AS</li>
  </ul>
  
  <p>Why?   </p>