问MSSQL中的事务是否会锁定表

EN

if ( sqlsrv_begin_transaction( $dbConnection ) === false ) {
    die( print_r( sqlsrv_errors(), true ));
}
$query = "INSERT INTO order_table (name,description,created_at) VALUES ('test_name','test_Transaction','some_date')";
$stmt1 = sqlsrv_query($dbConnection ,$query) or die('MSSQL error: ' . mssql_get_last_message());

$query = "INSERT INTO other_details_table (order_id,details) VALUES ('1234','order_details')";
$stmt2 = sqlsrv_query($dbConnection ,$query) or die('MSSQL error: ' . mssql_get_last_message());

sleep('20'); // used to delay the transaction time

/* If both queries were successful, commit the transaction. */
/* Otherwise, rollback the transaction. */
if( $stmt1 && $stmt2 ) {
 sqlsrv_commit( $conn );
 echo "Transaction committed.<br />";
 } else {
 sqlsrv_rollback( $conn );
 echo "Transaction rolled back.<br />";
}