title: Running SQL queries Async
body: <p>Is it possible to run queries in async in SQL Server. For example if I need to run following query</p>
  
  <pre><code>SELECT VALUE FROM DBO.fn1(@Input1)
  UNION
  SELECT VALUE FROM DBO.fn2(@Input2)
  UNION
  SELECT VALUE FROM DBO.fn3(@Input3)
  UNION
  SELECT VALUE FROM DBO.fn4(@Input4)
  </code></pre>
  
  <p>OR without <code>UNION</code></p>
  
  <p>For Example Following queries will return 3 result set. Can I run all these in parallel.</p>
  
  <pre><code>SELECT [COLUMN1...COLUMNN] FROM [TABLE1...TABLEN]
  SELECT [COLUMN1...COLUMNN] FROM [TABLE1...TABLEN]
  SELECT [COLUMN1...COLUMNN] FROM [TABLE1...TABLEN]
  </code></pre>
  
  <p>I tried google but not able to find anything for running queries in parallel, similar like Task based programming in C#</p>