Set transaction isolation level

[kbarbounakis]

Description

It would be very useful to have an option to set sql server transaction isolation in order to control locking behavior

SQL Server Transaction Isolation Level:

https://learn.microsoft.com/en-us/sql/t-sql/statements/set-transaction-isolation-level-transact-sql?view=sql-server-ver16

Solution
Use an option to define isolation level:

SET TRANSACTION ISOLATION LEVEL
    { READ UNCOMMITTED
    | READ COMMITTED
    | REPEATABLE READ
    | SNAPSHOT
    | SERIALIZABLE
    }