database query history executed SQL statements

You might want to query a previously executed statement during normal debugging. The following is a query history execution statement in sqlserver2008.

SELECT TOP  + --creation TimeQs.creation_time,--Query StatementsSUBSTRING(ST.text, (Qs.statement_start_offset/2)+1, (( CaseQs.statement_end_offset when -1  Then datalength(St.text) ELSEQs.statement_end_offsetEND -Qs.statement_start_offset)/2)+ 1 )  asStatement_text,--Execute textSt.text, --Execution PlanQs.total_worker_time, Qs.last_worker_time, Qs.max_worker_time, Qs.min_worker_time fromsys.dm_exec_query_stats QS--Key Words CrossAPPLY sys.dm_exec_sql_text (qs.sql_handle) STWHEREQs.creation_timebetween '2017-1-03 09:00:00'  and '2017-12-03 11:00:00' --and st.text like '% 'ORDER  byQs.creation_timeDESCSELECT TOP  + --creation TimeQs.creation_time,--Execute textSt.text fromsys.dm_exec_query_stats QS--Key Words CrossAPPLY sys.dm_exec_sql_text (qs.sql_handle) STWHEREQs.creation_timebetween '2017-1-03 09:00:00'  and '2017-12-03 11:00:00'  andSt.text  not  like '%select * from T_locationinfo WHERE strcliplogicid in (%' ORDER  byQs.creation_timeDESC

database query history executed SQL statements