Get Cahced Queries

SELECT

[Text], *

FROM

sys.dm_exec_query_stats AS deqs

CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest