游标
摘要：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
阅读(58)
推荐(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
阅读(97)
推荐(0) 编辑
