Re: Select while insert on another transaction gives unexpected results

On Thu, 15 Mar 2018 at 12:23 Wallace Turner wrote: > 1) you batch insert into a table using a transaction (say 1000 rows) > What are you using to do the insert? David. -- David Connors da...@connors.com | @davidconnors | https://t.me/davidconnors | LinkedIn | +61

RE: Select while insert on another transaction gives unexpected results

...@ozdotnet.com <ozdotnet-boun...@ozdotnet.com> *On Behalf Of *Wallace Turner *Sent:* Thursday, 15 March 2018 1:23 PM *To:* ozDotNet <ozdotnet@ozdotnet.com> *Subject:* Select while insert on another transaction gives unexpected results The crux of the problem: 1) you batch insert into a

RE: Select while insert on another transaction gives unexpected results

-boun...@ozdotnet.com <ozdotnet-boun...@ozdotnet.com> *On Behalf Of *Wallace Turner *Sent:* Thursday, 15 March 2018 1:23 PM *To:* ozDotNet <ozdotnet@ozdotnet.com> *Subject:* Select while insert on another transaction gives unexpected results The crux of the problem: 1) you

Select while insert on another transaction gives unexpected results

either all 1000 rows or none. I am not using anything other than the default settings (no read uncommitted) This question has already been asked: https://dba.stackexchange.com/questions/75848/sql-server-select-while-insert-on-another-transaction-gives-unexpected-results However I'm asking here