navicat查询历史执行语句

这将显示最近的 100 个执行记录，按最后执行时间的降序排列。您可以根据需要更改 TOP 数量和排序顺序。

SELECT TOP 100

    qs.last_execution_time,

    DB_NAME(st.dbid) AS database_name,

    OBJECT_NAME(st.objectid, st.dbid) AS object_name,

    SUBSTRING(st.text, (qs.statement_start_offset/2)+1,

        ((CASE qs.statement_end_offset

          WHEN -1 THEN DATALENGTH(st.text)

          ELSE qs.statement_end_offset

         END - qs.statement_start_offset)/2)+1) AS executed_sql

FROM sys.dm_exec_query_stats AS qs

CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st

ORDER BY qs.last_execution_time DESC;