利用  sys.dm_exec_query_stats 跟 sys.dm_exec_sql_text

來查詢最近下過的語法

SELECT
creation_time,CA.dbid,CA.objectid,
CA.text
FROM
sys.dm_exec_query_stats 
CROSS APPLY
sys.dm_exec_sql_text(sql_handle) CA
where creation_time between dateadd(n,-1,getdate()) and getdate()
ORDER BY creation_time DESC

sys.fn_get_sql (Transact-SQL)

語法

sys.fn_get_sql ( SqlHandle )

DECLARE @vsql_handle varbinary(64);
select top 1 @vsql_handle=sql_handle from sys.dm_exec_query_stats 
where creation_time between dateadd(n,-1,getdate()) and getdate() order by creation_time desc
select * from sys.fn_get_sql(@vsql_handle)