title: sqlsrv UPDATE statement runs but doesn't update DB
body: <p>I have an issue where my PHP sqlsrv UPDATE statement runs and doesn't return any errors but nothing in the DB ever changes and the row is not actually updated. Is there something I am missing that would allow this query to appear to run successfully but not update the row?</p>
  
  <p>I have checked that the update statement runs in SQL server management studio and it updates the row.</p>
  
  <pre><code>$visitquery = "UPDATE tblVisit SET CalledInBy='WINNER' WHERE VisitID='3679061'";            
  
                      $visitClose = sqlsrv_prepare($connect,$visitquery);
                      if( sqlsrv_execute( $visitClose))
                          {
                                echo "Statement executed.\n &lt;br /&gt;";
                          }
                          else
                          {
                               echo "Error in executing statement.\n";
                               die( print_r( sqlsrv_errors(), true));
                          } 
  </code></pre>