关于 sp_who2的引用方法？

Question

各位高手，我想用sp_who2和dbcc inputbuffer();显示当前占用最多时间或内存的进程

我的想法如下，但有错误提示，应该怎么改，谢谢！

dbcc inputbuffer(select top 1 SPID FROM SP_who2 order by CPUTime desc);

Answer 1

Can't do that, you may need dynamic sql here.

Answer 2

DECLARE @spid int;
SELECT TOP 1 @spid = spid
FROM master..sysprocesses
WHERE spid > 50
ORDER BY cpu DESC
DBCC INPUTBUFFER(@spid)