MS-SQL 查詢執行過的語法

 MS-SQL 查詢執行過的語法

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