title: Change returned table name from stored procedure at the SQL side
body: <p>I have written a single stored procedure that returns 2 tables: </p>
  
  <pre><code>select * 
  from workers
  
  select *
  from orders
  </code></pre>
  
  <p>I call this stored procedure from my C# application and get a <code>DataSet</code> with two tables, and everything is working fine.</p>
  
  <p>My question is how can I change the tables name <strong>at the SQL Server side</strong> so that in the C# side I will be able to access it via a name (instead of <code>Tables[0]</code>):</p>
  
  <pre><code>myDataSet.Tables["workers"]...
  </code></pre>
  
  <p>I tried to look for the answer in Google but couldn't find it. Maybe the search keywords was not sufficient.</p>