SQL2005+的语法UPDATE T1
SET Val1=T3.Val1
FROM #G_Goods T1
CROSS APPLY(SELECT TOP 1 Val1 FROM #G_Goods T2 WHERE T1.ID>=T2.ID AND T2.Val1>0 ORDER BY T2.ID DESC)T3
WHERE T1.Val1=0如果是SQL2000,我想,可以直接加个条件WHERE Val1=0 也会快很多
SET Val1=T3.Val1
FROM #G_Goods T1
CROSS APPLY(SELECT TOP 1 Val1 FROM #G_Goods T2 WHERE T1.ID>=T2.ID AND T2.Val1>0 ORDER BY T2.ID DESC)T3
WHERE T1.Val1=0如果是SQL2000,我想,可以直接加个条件WHERE Val1=0 也会快很多
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货