摘要:
CREATE TABLE #Lock ( SPID INT , DBID INT , OBJID INT , NAME VARCHAR(500), INDID INT , TYPE VARCHAR(100) , RESOURCE VARCHAR(100) , MODE VARCHAR(100) , STATUS VARCHAR(100) ) --2.Store Lock infoINSERT INTO #Lock(SPID,DBID,OBJID,INDID,TYPE,RESOURCE,MODE,STATUS) EXEC SP_LOCK--3.Update nameUPDATE l SET l. 阅读全文