MSSQL - Currency Control

Set Transaction Isolation Level
{
    Read Uncommitted |
    Read Committed (default) |
    Repeatable Read |
    Snapshot |
    Serializable
}

Article: Locking and row versioning