监测服务器是否出现死锁或者因阻塞时间较长超时
同时优化你的语句DECLARE @D SMALLDATETIME --过时日期SET @D = DATEADD(MONTH,-1,GETDATE())
DELETE PassRep
FROM (SELECT TOP 500 UserID,PassTime
FROM PassRep WHERE PassTime < @D) AS T1
WHERE PassRep.UserID = T1.UserID AND PassRep.PassTime = T1.PassTime
同时优化你的语句DECLARE @D SMALLDATETIME --过时日期SET @D = DATEADD(MONTH,-1,GETDATE())
DELETE PassRep
FROM (SELECT TOP 500 UserID,PassTime
FROM PassRep WHERE PassTime < @D) AS T1
WHERE PassRep.UserID = T1.UserID AND PassRep.PassTime = T1.PassTime
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货