OK, go to the database log to look for, through the time, keyword batch match. All you can think of is to use it.
Let's assume that you've executed it. No? Well, either it's too simple, or you're too easy.
Copy Code code as follows:
SELECT Top 1000
--Creation time
Qs.creation_time,
--Query statement
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,
--Execute text
St.text,
--Implementation Plan
Qs.total_worker_time,
Qs.last_worker_time,
Qs.max_worker_time,
Qs.min_worker_time
From
Sys.dm_exec_query_stats QS
--Key words
CROSS APPLY
Sys.dm_exec_sql_text (Qs.sql_handle) ST
WHERE
Qs.creation_time BETWEEN ' 2011-10-20 16:00:00 ' and ' 2011-10-20 17:00:00 '
And st.text like '% percent '
ORDER BY
Qs.creation_time DESC
SQL Server 2005 's new cross apply and outer apply JOIN statements are used to cross join table-valued functions (functions that return a table result set), and more importantly, the parameters of this function are fields from another table.
"SQL Server" CROSS apply and outer application
