Running SQL queries Async
<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>