The tab made in the transaction is visible SELECT before the transaction

Question

I need confirmation.

Client 1 inserts rows into the table inside the transaction.

Client 2 will query this table using SELECT. If at this isolation level of the client is set to READ COMMITTED, can you confirm that SELECT will not return rows that have not yet been executed by client 1.

thank

Answer 1

It depends on the level of transaction isolation. If the isolation level is indeed “Read Committed”, other connections cannot see rows that were inserted by another client in a transaction that has not yet been committed.

Some reading:

• MSDN

Answer 2

, . READ COMMITTED , , , .

Answer 3

.

MSDN , () :

, , , . . , phantom . SQL Server.

SELECT READ UNCOMMITTED, , , .