select 
    t.text
from sys.dm_exec_cached_plans cp
cross apply sys.dm_exec_plan_attributes(cp.plan_handle) a 
cross apply sys.dm_exec_sql_text(cast(a.value as varbinary(64))) t
where 
    a.attribute = 'sql_handle'

select 
	t.*
from sys.dm_exec_cached_plans cp
cross apply sys.dm_exec_plan_attributes(cp.plan_handle) a 
outer apply sys.dm_exec_sql_text(cp.plan_handle) t
where 
	a.attribute = 'user_id'
	and a.value = cast(USER_ID() as sql_variant)
	and cp.objtype = 'adhoc'
	and cp.cacheobjtype = 'Compiled Plan'