title: Plan not shown as hyperlink when selected from sys.dm_exec_text_query_plan
body: <p>I want do see the cached plans of queries that were executed on my SQLServer.</p>
  
  <p>When I query the plan from <code>sys.dm_exec_query_plan</code> the SQLServer Management Studio nicely displays the plan as a hyperlink. I click this link, a new tab opens and displays the plan.</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT p.query_plan
  FROM sys.dm_exec_cached_plans ps
  OUTER APPLY sys.dm_exec_query_plan(ps.plan_handle) p
  </code></pre>
  
  <p>I read <code>sys.dm_exec_query_plan</code> may return <code>NULL</code> under certain cirumstances and therefore want to query my plan data from <code>sys.dm_exec_text_query_plan</code> </p>
  
  <p></p>
  
  <pre><code>SELECT p.query_plan
  FROM sys.dm_exec_cached_plans ps
  OUTER APPLY sys.dm_exec_text_query_plan(ps.plan_handle, 0, -1) p
  </code></pre>
  
  <p>Now, in the results pane, the query plan is not displayed as a hyperlink. How can I view this plan in a graphic display?</p>