Nu tai pirmam thread'ui uzrakinus visa lentele, antras thread'as negales select'o padaryti (jei kokio dirty read'o neijungsi priverstinai su NOLOCK). On 2010.05.28 12:19, 2x50 wrote: > Tada klausima toks - kaip sita problema pades isspresti visos lenteles blokavimas vietoj vieno iraso blokavimo? > > "rl"<ask@me.for> wrote in message news:htl6se$vgm$1@trimpas.omnitel.net... >> UPDATE Jobs >> SET InUseBy = 'Jonas' >> WHERE DateCreated = (SELECT MIN(DateCreated) FROM Jobs WHERE InUseBy IS NULL) >> >> 1. Paleidi 2 tokius pacius update'us vienu metu >> 2. 1-as ivykdo (SELECT MIN(DateCreated) FROM Jobs WHERE InUseBy IS NULL). Gauna DateCreated reiksme >> 3. 2-as ivykdo (SELECT MIN(DateCreated) FROM Jobs WHERE InUseBy IS NULL) gauna ta pacia DateCreated reiksme >> 4. 1-as uzsilockina update'inimui konkretu irasa >> 5. 2-as bando lockinti ta pati irasa ir laukia >> 6. 1-as pakeicia InUseBy = 'Jonas' ir paleidzia lock'a >> 7. 2-as uzsilockina irasa, pakeicia InUseBy = 'Petras' ir paleidzia. >> >> Galima situacija? > >