Detect lock at sqlserver 2008
时间:2010-11-25 来源:netfuns
DECLARE @sqltext VARBINARY(128)
SELECT @sqltext = sql_handle
FROM sys.sysprocesses
WHERE spid = 58
SELECT TEXT
FROM ::fn_get_sql(@sqltext)
GO
相关阅读 更多 +
时间:2010-11-25 来源:netfuns
DECLARE @sqltext VARBINARY(128)
SELECT @sqltext = sql_handle
FROM sys.sysprocesses
WHERE spid = 58
SELECT TEXT
FROM ::fn_get_sql(@sqltext)
GO