SET TRANSACTION ISOLATION LEVEL#
Controls the locking and row versioning behavior of Transact-SQL statements issued by a connection .
Syntax#
SET TRANSACTION ISOLATION LEVEL
{ READ UNCOMMITTED
| READ COMMITTED
| REPEATABLE READ
| SNAPSHOT
| SERIALIZABLE
}
Remarks#
Argument values are ignored and do not change the default behavior.
Permissions#
Requires membership in the public role.
Examples#
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;