connector-x
connector-x copied to clipboard
Set TRANSACTION ISOLATION LEVEL ?
Queries appear to default to isolation level READ COMMITTED.
If a different level was desired, such as SET TRANSACTION LEVEL READ UNCOMMITTED was desired, can this be set in Connector-X?
Adding them as an initial separate statement to the SQL query results in an error:
RuntimeError: MsSQL failed to get the columns of query: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED