22,209
社区成员
发帖
与我相关
我的任务
分享
@a3 varchar(50),
@a1 varchar(50),
@a4 varchar(8000),
@b1 varchar(50),
@a2 datetime
as
update table1 set a1=@b1,a2=@a2 where a3=@a3 and a1=@a1 and a4=@a4
@a3 varchar(50),
@a1 varchar(50),
@a4 varchar(8000),
@b1 varchar(50),
@a2 datetime
as
update table1 WITH (ROWLOCK) set a1=@b1,a2=@a2 where a3=@a3 and a1=@a1 and a4=@a4
拆分为批处理
set rowcount 5000;
while 1=1
begin
update table1 set a1=@b1,a2=@a2 where a3=@a3 and a1=@a1 and a4=@a4....
if @@rowcount<5000 break;
end