SqlServer查询历史某一时间段写的Sql脚本

SELECT TOP 1000
--创建时间
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 '2022-12-06 12:00:00' AND '2022-12-06 19:11:00'
AND ST.text  LIKE '%请假结束日期%'
ORDER BY
QS.creation_time DESC