title: with(nolock) , (nolock) , nolock differences?
body: <p><strong>I know <code>with(nolock)</code> and <code>(nolock)</code> are the same or almost the same.</strong> <a href="https://stackoverflow.com/q/12112855/352101"><strong>REF:with(nolock) or (nolock) - Is there a difference?</strong></a></p>
  <p>but how about <code>nolock</code>? You can use either of them in <code>select</code> and the only notable difference I can see is when using alias that you can write:</p>
  <p><code>select * from table1 as mytable with(nolock)</code></p>
  <p>or</p>
  <p><code>select * from table1 as mytable (nolock)</code></p>
  <p>but you can't write:</p>
  <p><code>select * from table1 as mytable nolock</code></p>
  <p><strong>PS</strong>: I'm not discussing <code>nolock</code> is good or bad here :)</p>