筆記一下 查詢過去的語法

 查詢過去的語法


SELECT
QS.creation_time,
ST.text
FROM
sys.dm_exec_query_stats QS
CROSS APPLY
sys.dm_exec_sql_text(QS.sql_handle) ST
where QS.creation_time between '2017-11-17 10:23:01.500' and '2017-11-17 23:23:01.500'
ORDER BY
QS.creation_time DESC