SQlserver 2000 根据spid 查询执行的SQL

</p>

<p>declare @spid int;
declare @sql_handle binary(20);
set @spid = 437
SELECT @sql_handle = sql_handle
FROM sysprocesses As A with (nolock)
where spid = @spid
select text
from ::fn_get_sql(@sql_handle)</p>

<p>

发表评论

邮箱地址不会被公开。 必填项已用*标注