搬运随笔四

插入6位随机数sql

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  abs返回绝对值
 set @i=@i+1
end