Non Repeatable Read-SQL Server-Concurrency problem


Non Repeatable Read is also one of the concurrency problem in SQL Server. And it also causes confusion when two or more user working/reading on the same data.

Let see the situation, how problem occurs?
When one transaction reads the same data twice and another transaction updates that data in between the first and second read of transaction one.

See in the example below:-

non-repeatable-read | SQL Server | Academy4Code.com
non-repeatable-read | SQL Server | Academy4Code.com

 

As per John, the marks of Robin’s should not be changed from 28 to 42. This is the situation in sql Server called as non repeatable read in SQL Server.

 

please write at us, if you have any query overravindra@academy4code.comandacademy4code@gmail.com

Ravindra Kumar is a Programmer and an independent consultant from India. He has been a part of the industry for more than 6 years. During his career, he has worked on mutiple projects of the USA and of India (Technology Evangelist at Microsoft). He received his Bachelors of Engineering from Punjan Technical University. He has been a regular speaker of SQL Sessions in Indian IT Company.

For more, you can consult at ravindra@Academy4Code.com