title: Deleted records are selectable in the same transaction in SQL Server
body: <p>I am using the <code>mssql-jdbc</code> JDBC driver to do the following in a single transaction.</p>
  <p>Executed the following statement:</p>
  <pre><code>delete from table1
  </code></pre>
  <p>There were around 10 records in the table which were deleted (execute update returned 10). Then, immediately following the delete, executed the following select statement:</p>
  <pre><code>select count(*) from table1
  </code></pre>
  <p>Resultset said that there are still 10 records.</p>
  <p>In other DBs like Oracle and Postgres, we get 0, which is what I am expecting.</p>
  <p>I do not want autocommit=true behaviour. Also, the two statements need to execute in the same transaction.</p>
  <p>Is there anything I can do to get the behaviour I want?</p>