title: syntax for nolock in sql
body: <p>I have seen sql statements using nolock and with(nolock)
  e.g - </p>
  
  <pre><code>select * from table1 nolock where column1 &gt; 10
  </code></pre>
  
  <p>AND</p>
  
  <pre><code>select * from table1 with(nolock) where column1 &gt; 10
  </code></pre>
  
  <p>Which of the above statements is correct and why? </p>