title: SQL Server: How to change collation of all columns of my select on the fly
body: <p>I need to query something from a table in my database but the collation of some columns are different from the one I need.</p>
  
  <p>I found how to change the collation of one column on the fly like this:</p>
  
  <pre><code>SELECT 
    u.name  COLLATE Latin1_General_CI_AS AS 'User'(...)
  </code></pre>
  
  <p>But the problem is that are more than 150 columns that need a COLLATION change on the fly (don't ask me why because we can't change the collation of the entire table even though I think it would be the best option).</p>
  
  <p>So the main question is:
  <code>Is there a way to set the COLLATION to all columns of my query?</code></p>