sql生成手机号码

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/

 

转载于:https://www.cnblogs.com/dupeng0811/archive/2013/03/04/2942958.html