SQLServer批量更新

1、直接用top N来实现批量更新update top(1000) table1 set SysNo = 0 ,UpdateTime = getdate() where Status not in (-1,-2,-3,-4,-5,4) and StockStatus <> 2 and isnull(CaiSysNo,0) = 0 and SysNo = 1; 2、用中间表实现批量更新select SysNo into table1_temp01FROM    table1 WHERE EXISTS (SELECT 1 FROM table1_History..table1_History a WHERE a.SysNo=table1.SysNo); UPDATE TOP(5000)from table1where SysNo in(select SysNo from table1_temp01);