title: R Getting the number of rows which have been updated
body: <p>How can we get the <strong>number of rows</strong> affected by the executed UPDATE query?</p>
  
  <pre><code>r &lt;- sqlQuery(channel, 'UPDATE foo SET bar = 1')
  </code></pre>
  
  <p>What I get (from a connection to a MS SQL Server DB) is just a <code>character(0)</code>...</p>