title: What is the difference between square brackets and single quotes for aliasing in SQL Server?
body: <p>I have seen some people alias column names using single quotes eg:</p>
  
  <pre><code>select orderID 'Order No' from orders
  </code></pre>
  
  <p>and others use square brackets eg:</p>
  
  <pre><code>select orderID [Order No] from orders
  </code></pre>
  
  <p>I tend to use square brackets. Is there any preference/difference?</p>