TSQL:获取最后查询 [英] TSQL: Get Last Queries Ran
本文介绍了TSQL:获取最后查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
是否有一种方法可以获取最后几个查询的SQL文本?
Is there a way to get the SQL text for the last few queries?
我正在使用Microsoft SQL Server 2005
I am using Microsoft SQL Server 2005
推荐答案
是的,请看一下,这将为您提供50条最近执行的SQL语句
Yes, take a look, this will give you the 50 most recent executed SQL statements
仅适用于sql 2005及更高版本
sql 2005 and up only
SELECT TOP 50 * FROM(SELECT COALESCE(OBJECT_NAME(s2.objectid),'Ad-Hoc') AS ProcName,
execution_count,s2.objectid,
(SELECT TOP 1 SUBSTRING(s2.TEXT,statement_start_offset / 2+1 ,
( (CASE WHEN statement_end_offset = -1
THEN (LEN(CONVERT(NVARCHAR(MAX),s2.TEXT)) * 2)
ELSE statement_end_offset END)- statement_start_offset) / 2+1)) AS sql_statement,
last_execution_time
FROM sys.dm_exec_query_stats AS s1
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS s2 ) x
WHERE sql_statement NOT like 'SELECT TOP 50 * FROM(SELECT %'
--and OBJECTPROPERTYEX(x.objectid,'IsProcedure') = 1
ORDER BY last_execution_time DESC
这篇关于TSQL:获取最后查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文