插入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
搬运随笔四
原文:http://www.cnblogs.com/2333hh/p/5226794.html