title: Fetching only several result sets
body: <p>The question is quite simple. I have following SQL:</p>
  
  <pre><code>SELECT *
  FROM T1
  
  SELECT *
  FROM T2
  
  SELECT *
  FROM T3
  
  SELECT *
  FROM T4
  </code></pre>
  
  <p>In one case I need all four data sets, in other I need only <code>T1</code> and <code>T2</code>.
  Should I write another stored procedure which returns only <code>T1</code> and <code>T2</code>, or can I just skip last two data sets (without executing batch on SQL engine). </p>
  
  <p>I mean if I fetch only <code>T1</code> and <code>T2</code> with following code</p>
  
  <pre><code>var reader = command.ExecuteReader();
  ReadSet1();
  reader.NextResult();
  ReadSet2();
  reader.Close()
  </code></pre>
  
  <p>does SQL server actually executes batches for <code>T3</code> and <code>T4</code>?</p>