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_temp01
FROM table1
WHERE EXISTS (SELECT 1 FROM table1_History..table1_History a WHERE a.SysNo=table1.SysNo);
UPDATE TOP(5000)
from table1
where SysNo in
(select SysNo from table1_temp01);
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22996654/viewspace-2665035/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
SQLServer查询所有数据库大小
请登录后发表评论
登录
全部评论
