title: Sql Server read uncommitted field level variance?
body: <p>If my connection allows dirty reads, is it possible that I would get inconsistent results from multiple fields of the same row?  Example:</p>
  
  <p>Connection 1:</p>
  
  <pre><code>Update table1 set col1 = 1, col2 = 1 where primarykey = 1
  Update table2 set col1 = 2, col2 = 2 where primarykey = 1
  </code></pre>
  
  <p>Connection 2:</p>
  
  <pre><code>select col1, col2 from table1 where primarykey = 1
  </code></pre>
  
  <p>is it possible that connection 2 could see non-equal values for col1 and col2?
  e.g., col1=1 and col2=2 ,  or,  col1=2 and col2=1</p>