22,209
社区成员
发帖
与我相关
我的任务
分享
select 1
select * from sys.dm_exec_requests
select * from sys.dm_exec_query_stats
select text from sys.dm_exec_sql_text((select sql_handle from sys.dm_exec_query_stats
where statement_end_offset = (select MAX(statement_end_offset) from sys.dm_exec_query_stats)))
select text from sys.dm_exec_sql_text((select sql_handle from sys.dm_exec_requests
where statement_end_offset = (select MAX(statement_end_offset) from sys.dm_exec_requests)))
declare @sql_handle varbinary(64)
set @sql_handle = (select sql_handle from sys.dm_exec_requests
where statement_end_offset = (select MAX(statement_end_offset) from sys.dm_exec_requests))
select text from sys.dm_exec_sql_text(@sql_handle)