SqlServer查询数据改动历史记录

select top1000 [QS].[creation_time],substring([ST].[text],([QS].[statement_start_offset] / 2) + 1,((case [QS].[statement_end_offset] when - 1 then datalength([st

安夜的cookie

6229人浏览 · 2021-12-30 09:27:42

安夜的cookie · 2021-12-30 09:27:42 发布

select top
    1000 [QS].[creation_time],
         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 [statement_text],
         [ST].[text],
         [QS].[total_worker_time],
         [QS].[last_worker_time],
         [QS].[max_worker_time],
         [QS].[min_worker_time]
from [sys].[dm_exec_query_stats] [QS]
         cross apply [sys].[dm_exec_sql_text]([QS].[sql_handle]) [ST]
-- 时间段设置
where [QS].[creation_time] between '2021-12-10 00:00:00'
    and '2021-12-29 23:59:00' 
  -- SQL 语句模糊匹配，如insert、SELECT、UPDATE、DELETE
  and [ST].[text] like '%DELETE%'
order by [QS].[creation_time] desc