sql 循环更新随机生成的6位数字

declare @i int
set @i=0
while @i<1073
begin

update Actor set AtrPwd = RIGHT(100000000 + CONVERT(bigint, ABS(CHECKSUM(NEWID()))), 6) --where aid=2

set @i=@i+1
end