死锁
-
编辑 删除
【sqlserver】杀掉所有死锁进程
DECLARE@USER_ID INT, @KILLCMD VARCHAR(100)-- 根据选择条件，选择出应该取消的进程DECLARE cur_lock CURSOR FORSELECT spid FROM master..sysprocessesWHEREblocked = 0AND spid IN (SELECT blocked FROM mas...
