Transact-SQL, SQL Server, SET TRANSACTION ISOLATION LEVEL.
, , . , , , FROM .
SET TRANSACTION ISOLATION LEVEL
{ READ UNCOMMITTED
| READ COMMITTED
| REPEATABLE READ
| SNAPSHOT
| SERIALIZABLE
}
READ UNCOMMITTED
, , , .
, READ UNCOMMITTED, , . READ UNCOMMITTED , , . , . . , NOLOCK SELECT . .
SQL Server 2008 :
READ COMMITTED READ_COMMITTED_SNAPSHOT, ON;
(SNAPSHOT).
READ COMMITTED
, , , . . , . SQL Server .
READ COMMITTED READ_COMMITTED_SNAPSHOT.
READ_COMMITTED_SNAPSHOT OFF ( ), Database Engine . , , . .
|
|
READ_COMMITTED_SNAPSHOT ON, Database Engine , . .
READ_COMMITTED_SNAPSHOT , ALTER DATABASE. ALTER DATABASE . .
REPEATABLE READ
, , , , , , , .
, , . , . , , . , . , , , READ COMMITTED. .
SNAPSHOT
, , , , . , . , , , . .
, . . , , .
, , . . .
, , ALLOW_SNAPSHOT_ISOLATION ON. , ALLOW_SNAPSHOT_ISOLATION .
, ; . , . .
|
|
, , . , UPDATE, SELECT , .
SERIALIZABLE
.
, , .
, , .
, , , .
, , . , , . , - , . . , .
- .
, .
, . , READ COMMITTED REPEATABLE READ, , , , , . , , . , REPEATABLE READ , .
, . SNAPSHOT. . , SNAPSHOT, .
, , , . , , . , READ COMMITTED SERIALIZABLE, , , .
SET TRANSACTION ISOLATION LEVEL , , . , REPEATABLE READ , , SERIALIZABLE, , REPEATABLE READ.
|
|
. Transact-SQL SQL Server .
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
GO
BEGIN TRANSACTION;
GO
SELECT *
FROM HumanResources.EmployeePayHistory;
GO
SELECT *
FROM HumanResources.Department;
GO
COMMIT TRANSACTION;
GO