SQL SERVER中事务隔离级别的实例分析

Example Analyzing of Transaction Isolation Level in SQL SERVER

通过具体实例分析了SQLSERVER2000在不同的事务隔离级别中,事务并发操作带来的数据读取的不一致性,从而为具体应用程序既要保证数据完整、一致性又要提高事务并发控制策略中事务的并发程度提供了一种依据和参考。

Through concrete examples,this article analyzes the data acess’s inconsistency that is brought by the concurrent operation of transaction in the sql server 2000’s different transaction isolation levels,so as to provide the application a basis and reference that may ensure data integrity and consistency and raise the transaction’s concurrency degree in the transacton concurrency control strategy.