SELECT SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1,
((CASE qs.statement_end_offset
WHEN -1 THEN DATALENGTH(qt.TEXT)
ELSE qs.statement_end_offset
END - qs.statement_start_offset)/2)+1) as qu,
qs.last_execution_time
FROM sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) qt
CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp
WHERE (qt.text LIKE '%已列印%' and qt.text LIKE '%update%') and (NOT (qt.text LIKE '%select%') and NOT qt.text LIKE '%@%') and (last_execution_time >= CONVERT(datetime, convert(varchar(10), GETDATE() ,120), 120))
ORDER BY qs.last_execution_time DESC