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
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
转载于:https://www.cnblogs.com/mys0226/p/5751907.html