> Transaction A starts
> Transaction B starts
> TX B inserts many rows in table 1
> TX B commits
> TX A selects from table 1
>
> Can TX A see the rows that TX B committed?

Yes, if TX A has been started in READ COMMITTED isolation mode.


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com