新插入的记录是否可用于同一事务中的后续SQL命令?

假设我有一些C代码执行两个SQL命令:

var MyTransaction = DbConnection.BeginTransaction();
//using MyTransaction: INSERT INTO TABLE_1 (ID, SOURCE_FIELD) VALUES (99, 'HELLO')
//using MyTransaction: UPDATE TABLE_2 SET DESTINATION_FIELD = (SELECT SOURCE_FIELD FROM TABLE_1 WHERE ID = 99)
MyTransaction.Commit();

即使我直到最后才提交事务,第二条SQL语句是否会看到ID为“99”的新记录?