sqlserver 循环删除表中的数据,防止锁表,业务崩溃 

 
1 WHILE 1 = 1
2 BEGIN
3 DELETE TOP(500) FROM provincial_workform WHERE lrsj is null
4 IF @@rowcount < 500
5 BREAK;
6 END

 

posted @ 2023-11-29 15:20  aniymx  阅读(98)  评论(0)    收藏  举报