⟩ Do you know the isolation level that SQL Server support?
Isolation levels supported by SQL Server:
Read uncommitted: Lowest level of isolation
Read committed: Default
Repeatable read
Serializable: Highest level of isolation. All transactions are isolated from each other completely.