DECLARE @i int set @i = 1 WHILE @i < 10000 BEGIN insert into sj SELECT CONVERT(varchar, CAST(RAND()* (139 - 130) + 130 AS int)) + CONVERT(varchar, CAST(RAND() * (99999999 - 32928404) + 32928404 AS int)) SET @i = @i + 1 END
http://yopoing.blog.163.com/blog/static/21149536020093105737360/