Expert SQL Server In-Memory OLTP by Dmitri Korotkevitch

Author:Dmitri Korotkevitch
Language: eng
Format: epub, pdf
Publisher: Apress, Berkeley, CA

Session 1

Session 2

Results

begin tran

select ID, Col

from dbo.HKData

with (snapshot)

begin tran

update dbo.HKData

with (snapshot)

set Col = -3

where ID = 2

commit

update dbo.HKData

with (snapshot)

set Col = -2

where ID = 2

Msg 41302, Level 16, State 110, Line 1

The current transaction attempted to update a record that has been updated since this transaction started. The transaction was aborted.

Msg 3998, Level 16, State 1, Line 1

Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.

The statement has been terminated.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.