declare @i int
declare @j int
set @i=1
while @i<100
begin
set @j=1
while @j<6
begin
update dbo.RDS_EACP set userId=@j where id=@i
set @i=@i+1
set @j=@j+1
end
end
declare @i int
declare @j int
set @i=1
while @i<100
begin
set @j=1
while @j<6
begin
update dbo.RDS_EACP set userId=@j where id=@i
set @i=@i+1
set @j=@j+1
end
end