SELECT 
       QS.creation_time AS '执行时间' ,  
       ST.text AS '执行的SQL语句'
FROM   sys.dm_exec_query_stats QS
       CROSS APPLY 
sys.dm_exec_sql_text(QS.sql_handle) ST
ORDER BY QS.creation_time desc;