SQL Serverの動的管理ビューから、実行したSQL(とバインド変数)を取得する

SELECT SERVERPROPERTY('productversion') as VERSION;

SELECT
  query_plan
  , text 
FROM
  sys.dm_exec_query_stats 
  cross apply sys.dm_exec_query_plan(plan_handle) 
  cross apply sys.dm_exec_sql_text(sql_handle) 
ORDER BY
  last_execution_time DESC; 

(略)
<ParameterList>
  <ColumnReference Column="@P0"
  ParameterDataType="nvarchar(4000)"
  ParameterCompiledValue="N'TEST'" />
...
</ParameterList>
(略)

WITH XMLNAMESPACES( 
  DEFAULT 'http://schemas.microsoft.com/sqlserver/2004/07/showplan'
) 
SELECT
  -- 2. ParameterList/ColumnReferenceをパラメータ引数の分forで回す
  item.query( 
    '
        <parameters>
          {
            for $i in ColumnReference
              return <parameter>{string($i/@Column)},{string($i/@ParameterCompiledValue)}</parameter>
          }
        </parameters>
      '
  ) AS param
  , text 
FROM
  sys.dm_exec_query_stats 
  CROSS APPLY sys.dm_exec_query_plan(plan_handle) 
  CROSS APPLY sys.dm_exec_sql_text(sql_handle)
  -- 1. query_planからParameterListタグ下を取得
  OUTER APPLY query_plan.nodes( 
    '/ShowPlanXML/BatchSequence/Batch/Statements/StmtSimple/QueryPlan/ParameterList'
  ) AS T(item) 
ORDER BY
  last_execution_time DESC;

<p1:parameters xmlns:p1="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
  <p1:parameter>@P1,N'SAMPLE_PARAM2'</p1:parameter>
  <p1:parameter>@P0,N'SAMPLE_PARAM'</p1:parameter>
</p1:parameters>

(@P0 nvarchar(4000),@P1 nvarchar(4000))
SELECT
  *
FROM
  SAMPLESCHEMA.SAMPLETABLE 
WHERE
  testcol1 = @P0
AND
  testcol2 = @P1

<ShowPlanXML
xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan"
Version="1.6" Build="14.0.1000.169">
<BatchSequence>
  <Batch>
    <Statements>
      <StmtCursor
        StatementText="FETCH API_CURSOR000000000000XXXX" StatementId="1"
        StatementCompId="1" StatementType="FETCH CURSOR"
        RetrievedFromCache="true">
        <CursorPlan CursorName="API_CURSOR000000000000XXXX" />
      </StmtCursor>
    </Statements>
  </Batch>
  </BatchSequence>
</ShowPlanXML>

FETCH API_CURSOR000000000000XXXX