T-SQL ENHANCEMENTS CREATE TABLE snapTest ([id] INT IDENTITY,

T-SQL ENHANCEMENTS CREATE TABLE snapTest ([id] INT IDENTITY, col1 VARCHAR(15)) insert some data INSERT INTO snapTest VALUES(1, Niels ) Table 7-3: Example of SNAPSHOT Isolation Step User 1 User 2 1 SET TRANSACTION ISOLATION LEVEL SNAPSHOT BEGIN TRAN UPDATE snapTest SET col1 = NewNiels WHERE id = 1 2 SET TRANSACTION ISOLATION LEVEL SNAPSHOT BEGIN TRAN SELECT col1 FROM snapTest WHERE id = 1 ** receives value Niels 3 COMMIT TRAN 4 SELECT col1 FROM snapTest WHERE id = 1 ** receives value Niels 5 COMMIT TRAN 6 SELECT col1 FROM snapTest WHERE id = 1 ** receives value NewNiels

Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost Java Web Hosting services

Bookmark the permalink.

Comments are closed.