title: Will an EXISTS query still lock a table?
body: <pre><code>IF NOT EXISTS(SELECT * FROM MyTable WITH(nolock) WHERE Key = 'MyKey')
    INSERT MyTable(Key) Values('MyKey')
  </code></pre>
  
  <p>If The value does not exist in the table, does the query aquire a lock?</p>