Working with Stored Procedure and Plan Handle

To view cache plan of AdHoc queries : SELECT cplan.plan_handle, cplan.usecounts, cplan.objtype, qtext.text ,qplan.query_plan FROM sys.dm_exec_cached_plans AS cplan CROSS APPLY sys.dm_exec_sql_text(plan_handle) AS qtext CROSS APPLY sys.dm_exec_query_p...