03 2021 档案
游标
摘要:DECLARE Sub_CURSOU_MS CURSOR FOR SELECT FInkqty, FPrjsht, FMatno FROM #subworktimeink OPEN Sub_CURSOU_MS; FETCH NEXT FROM Sub_CURSOU_MS INTO @finkqty, 阅读全文
posted @ 2021-03-12 16:54 RookieBoy666 阅读(71) 评论(0) 推荐(0)
查看死锁
摘要:查看: --查询死锁 select request_session_id spid, OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type='OBJECT' 阅读全文
posted @ 2021-03-01 13:07 RookieBoy666 阅读(108) 评论(0) 推荐(0)