title: Multiple columns in OVER ORDER BY
body: <p>Is there a way to specify multiple columns in the OVER ORDER BY clause?</p>
  
  <pre><code>SELECT ROW_NUMBER() OVER(ORDER BY (A.Col1)) AS ID FROM MyTable A
  </code></pre>
  
  <p>The above works fine, but trying to add a second column does not work.</p>
  
  <pre><code>SELECT ROW_NUMBER() OVER(ORDER BY (A.Col1, A.Col2)) AS ID FROM MyTable A
  </code></pre>
  
  <blockquote>
    <p>Incorrect syntax near ','.</p>
  </blockquote>