Do I have to include "SELECT @@RowCount" if I have more than one SQL statement?
<p>I know that, if I execute a single SQL statement that UPDATEs or DELETEs some data, that it will return the <em>number of rows affected.</em></p>

<p>But if I have multiple SQL statements in a sql script, and I want to know the number of rows affected <em>from the last statement executed,</em> will it still return that automatically, or do I need a </p>

<pre><code>SELECT @@RowCount
</code></pre>

<p>at the end of the script?</p>

<p>The code in question is not a Stored Procedure.  Rather, it is a parameterized SQL script stored in an arbitrary location, executed using the <code>ExecuteStoreCommand</code> function in Entity Framework, as in:</p>

<pre><code>var numberOfRowsAffected = context.ExecuteStoreCommand&lt;int&gt;(mySqlScript, parameters);
</code></pre>