Access911.net   |   a9BBS   |   OTaA System  
  搜索文章:  
Access911欢迎您光临  
   主页      上传      繁體版       论坛     
设为首页  |  加入收藏   
  
你现在的位置:文章索引 -> 文章分类 -> ADP  
 首页|  近日更新|  下载  |  文章索引  |  搜索|  术语|  承接工程|  
 
系统正在加载内容,请耐心等待...
 
 查询
 窗体
 报表
 
 
 VBA
 函数
 ADO/DAO/ADO.NET
 API
 ADP
 安全
 发布
 OA
 ASP/ASP.NET
 其他语言
 控件
 DELPHI
 C#/.Net
 本站
 其他
 小例程
 常用软件
 参考文档
 业主作品
 网友大作
 
 
友情链接
 access911.net
 
访问人次
 1701950
 
站长 E-Mail
 net911@sina.com
 access911@gmail.com
 
RSS 订阅

显示附加信息 >>>

SqlServer生成随机姓名的脚本

作者:cg1  摘自:access911.net  :cg1  更新日期:2015-12-17  浏览人次:

 

drop table firstname
go

Create table FirstName(
    Id int IDENTITY(1,1) NOT NULL,
    Name nchar(1)
)
go
insert into firstname(name) values('蔼')
insert into firstname(name) values('霭')
insert into firstname(name) values('艾')
insert into firstname(name) values('爱')
insert into firstname(name) values('叆')
insert into firstname(name) values('安')
insert into firstname(name) values('岸')
insert into firstname(name) values('昂')
insert into firstname(name) values('傲')
insert into firstname(name) values('奥')
insert into firstname(name) values('八')
insert into firstname(name) values('巴')
insert into firstname(name) values('拔')
insert into firstname(name) values('灞')
insert into firstname(name) values('白')
insert into firstname(name) values('柏')
insert into firstname(name) values('半')
insert into firstname(name) values('邦')
insert into firstname(name) values('帮')
insert into firstname(name) values('榜')
insert into firstname(name) values('煲')
insert into firstname(name) values('薄')
insert into firstname(name) values('宝')
insert into firstname(name) values('保')
insert into firstname(name) values('葆')
insert into firstname(name) values('堡')
insert into firstname(name) values('豹')
insert into firstname(name) values('贝')
insert into firstname(name) values('蓓')
insert into firstname(name) values('本')
insert into firstname(name) values('苯')
insert into firstname(name) values('比')
insert into firstname(name) values('妣')
insert into firstname(name) values('彼')
insert into firstname(name) values('笔')
insert into firstname(name) values('弼')
insert into firstname(name) values('碧')
insert into firstname(name) values('壁')
insert into firstname(name) values('璧')
insert into firstname(name) values('标')
insert into firstname(name) values('骉')
insert into firstname(name) values('彪')
insert into firstname(name) values('飙')
insert into firstname(name) values('飇')
insert into firstname(name) values('宾')
insert into firstname(name) values('彬')
insert into firstname(name) values('斌')
insert into firstname(name) values('滨')
insert into firstname(name) values('冰')
insert into firstname(name) values('兵')
insert into firstname(name) values('秉')
insert into firstname(name) values('炳')
insert into firstname(name) values('波')
insert into firstname(name) values('玻')
insert into firstname(name) values('伯')
insert into firstname(name) values('帛')
insert into firstname(name) values('勃')
insert into firstname(name) values('博')
insert into firstname(name) values('渤')
insert into firstname(name) values('搏')
insert into firstname(name) values('卜')
insert into firstname(name) values('不')
insert into firstname(name) values('步')
insert into firstname(name) values('才')
insert into firstname(name) values('材')
insert into firstname(name) values('财')
insert into firstname(name) values('采')
insert into firstname(name) values('彩')
insert into firstname(name) values('睬')
insert into firstname(name) values('灿')
insert into firstname(name) values('粲')
insert into firstname(name) values('璨')
insert into firstname(name) values('仓')
insert into firstname(name) values('苍')
insert into firstname(name) values('沧')
insert into firstname(name) values('藏')
insert into firstname(name) values('策')
insert into firstname(name) values('岑')
insert into firstname(name) values('曾')
insert into firstname(name) values('婵')
insert into firstname(name) values('禅')
insert into firstname(name) values('镵')
insert into firstname(name) values('昌')
insert into firstname(name) values('常')
insert into firstname(name) values('嫦')
insert into firstname(name) values('厂')
insert into firstname(name) values('昶')
insert into firstname(name) values('畅')
insert into firstname(name) values('唱')
insert into firstname(name) values('超')
insert into firstname(name) values('焯')
insert into firstname(name) values('朝')
insert into firstname(name) values('潮')
insert into firstname(name) values('彻')
insert into firstname(name) values('掣')
insert into firstname(name) values('琛')
insert into firstname(name) values('瞋')
insert into firstname(name) values('臣')
insert into firstname(name) values('尘')
insert into firstname(name) values('辰')
insert into firstname(name) values('沉')
insert into firstname(name) values('忱')
insert into firstname(name) values('陈')
insert into firstname(name) values('宸')
insert into firstname(name) values('晨')
insert into firstname(name) values('成')
insert into firstname(name) values('丞')
insert into firstname(name) values('呈')
insert into firstname(name) values('诚')
insert into firstname(name) values('承')
insert into firstname(name) values('城')
insert into firstname(name) values('乘')
insert into firstname(name) values('铖')
insert into firstname(name) values('程')
insert into firstname(name) values('澄')
insert into firstname(name) values('橙')
insert into firstname(name) values('逞')
insert into firstname(name) values('痴')
insert into firstname(name) values('池')
insert into firstname(name) values('弛')
insert into firstname(name) values('驰')
insert into firstname(name) values('舂')
insert into firstname(name) values('崇')
insert into firstname(name) values('畴')
insert into firstname(name) values('初')
insert into firstname(name) values('础')
insert into firstname(name) values('楚')
insert into firstname(name) values('川')
insert into firstname(name) values('传')
insert into firstname(name) values('钏')
insert into firstname(name) values('创')
insert into firstname(name) values('春')
insert into firstname(name) values('纯')
insert into firstname(name) values('莼')
insert into firstname(name) values('淳')
insert into firstname(name) values('醇')
insert into firstname(name) values('祠')
insert into firstname(name) values('慈')
insert into firstname(name) values('赐')
insert into firstname(name) values('璁')
insert into firstname(name) values('聪')
insert into firstname(name) values('从')
insert into firstname(name) values('翠')
insert into firstname(name) values('村')
insert into firstname(name) values('存')
insert into firstname(name) values('达')
insert into firstname(name) values('答')
insert into firstname(name) values('大')
insert into firstname(name) values('代')
insert into firstname(name) values('岱')
insert into firstname(name) values('戴')
insert into firstname(name) values('黛')
insert into firstname(name) values('丹')
insert into firstname(name) values('蛋')
insert into firstname(name) values('澹')
insert into firstname(name) values('党')
insert into firstname(name) values('宕')
insert into firstname(name) values('荡')
insert into firstname(name) values('道')
insert into firstname(name) values('得')
insert into firstname(name) values('锝')
insert into firstname(name) values('德')
insert into firstname(name) values('的')
insert into firstname(name) values('灯')
insert into firstname(name) values('等')
insert into firstname(name) values('狄')
insert into firstname(name) values('迪')
insert into firstname(name) values('涤')
insert into firstname(name) values('笛')
insert into firstname(name) values('嫡')
insert into firstname(name) values('地')
insert into firstname(name) values('弟')
insert into firstname(name) values('娣')
insert into firstname(name) values('第')
insert into firstname(name) values('滇')
insert into firstname(name) values('典')
insert into firstname(name) values('电')
insert into firstname(name) values('坫')
insert into firstname(name) values('殿')
insert into firstname(name) values('蝶')
insert into firstname(name) values('丁')
insert into firstname(name) values('顶')
insert into firstname(name) values('鼎')
insert into firstname(name) values('定')
insert into firstname(name) values('丢')
insert into firstname(name) values('东')
insert into firstname(name) values('冬')
insert into firstname(name) values('咚')
insert into firstname(name) values('栋')
insert into firstname(name) values('逗')
insert into firstname(name) values('笃')
insert into firstname(name) values('度')
insert into firstname(name) values('多')
insert into firstname(name) values('铎')
insert into firstname(name) values('朵')
insert into firstname(name) values('娥')
insert into firstname(name) values('恩')
insert into firstname(name) values('儿')
insert into firstname(name) values('而')
insert into firstname(name) values('尔')
insert into firstname(name) values('迩')
insert into firstname(name) values('二')
insert into firstname(name) values('发')
insert into firstname(name) values('法')
insert into firstname(name) values('帆')
insert into firstname(name) values('凡')
insert into firstname(name) values('矾')
insert into firstname(name) values('樊')
insert into firstname(name) values('繁')
insert into firstname(name) values('范')
insert into firstname(name) values('梵')
insert into firstname(name) values('方')
insert into firstname(name) values('芳')
insert into firstname(name) values('访')
insert into firstname(name) values('昉')
insert into firstname(name) values('舫')
insert into firstname(name) values('放')
insert into firstname(name) values('飞')
insert into firstname(name) values('妃')
insert into firstname(name) values('非')
insert into firstname(name) values('菲')
insert into firstname(name) values('绯')
insert into firstname(name) values('蜚')
insert into firstname(name) values('霏')
insert into firstname(name) values('斐')
insert into firstname(name) values('翡')
insert into firstname(name) values('芬')
insert into firstname(name) values('丰')
insert into firstname(name) values('风')
insert into firstname(name) values('沣')
insert into firstname(name) values('枫')
insert into firstname(name) values('峯')
insert into firstname(name) values('峰')
insert into firstname(name) values('锋')
insert into firstname(name) values('逢')
insert into firstname(name) values('凤')
insert into firstname(name) values('俸')
insert into firstname(name) values('夫')
insert into firstname(name) values('鄜')
insert into firstname(name) values('扶')
insert into firstname(name) values('芙')
insert into firstname(name) values('蚨')
insert into firstname(name) values('涪')
insert into firstname(name) values('福')
insert into firstname(name) values('甫')
insert into firstname(name) values('辅')
insert into firstname(name) values('付')
insert into firstname(name) values('复')
insert into firstname(name) values('赋')
insert into firstname(name) values('富')
insert into firstname(name) values('馥')
insert into firstname(name) values('伽')
insert into firstname(name) values('改')
insert into firstname(name) values('干')
insert into firstname(name) values('刚')
insert into firstname(name) values('纲')
insert into firstname(name) values('罡')
insert into firstname(name) values('岗')
insert into firstname(name) values('高')
insert into firstname(name) values('杲')
insert into firstname(name) values('戈')
insert into firstname(name) values('歌')
insert into firstname(name) values('阁')
insert into firstname(name) values('格')
insert into firstname(name) values('葛')
insert into firstname(name) values('根')
insert into firstname(name) values('亘')
insert into firstname(name) values('耿')
insert into firstname(name) values('工')
insert into firstname(name) values('功')
insert into firstname(name) values('狗')
insert into firstname(name) values('枸')
insert into firstname(name) values('咕')
insert into firstname(name) values('孤')
insert into firstname(name) values('谷')
insert into firstname(name) values('骨')
insert into firstname(name) values('固')
insert into firstname(name) values('顾')
insert into firstname(name) values('关')
insert into firstname(name) values('观')
insert into firstname(name) values('莞')
insert into firstname(name) values('冠')
insert into firstname(name) values('光')
insert into firstname(name) values('广')
insert into firstname(name) values('瑰')
insert into firstname(name) values('贵')
insert into firstname(name) values('桂')
insert into firstname(name) values('国')
insert into firstname(name) values('果')
insert into firstname(name) values('海')
insert into firstname(name) values('亥')
insert into firstname(name) values('骇')
insert into firstname(name) values('含')
insert into firstname(name) values('函')
insert into firstname(name) values('琀')
insert into firstname(name) values('晗')
insert into firstname(name) values('涵')
insert into firstname(name) values('寒')
insert into firstname(name) values('罕')
insert into firstname(name) values('汉')
insert into firstname(name) values('涆')
insert into firstname(name) values('菡')
insert into firstname(name) values('翰')
insert into firstname(name) values('瀚')
insert into firstname(name) values('行')
insert into firstname(name) values('杭')
insert into firstname(name) values('航')
insert into firstname(name) values('豪')
insert into firstname(name) values('壕')
insert into firstname(name) values('濠')
insert into firstname(name) values('好')
insert into firstname(name) values('昊')
insert into firstname(name) values('浩')
insert into firstname(name) values('皓')
insert into firstname(name) values('颢')
insert into firstname(name) values('灏')
insert into firstname(name) values('禾')
insert into firstname(name) values('合')
insert into firstname(name) values('何')
insert into firstname(name) values('和')
insert into firstname(name) values('河')
insert into firstname(name) values('荷')
insert into firstname(name) values('菏')
insert into firstname(name) values('翮')
insert into firstname(name) values('贺')
insert into firstname(name) values('赫')
insert into firstname(name) values('鹤')
insert into firstname(name) values('恨')
insert into firstname(name) values('亨')
insert into firstname(name) values('恒')
insert into firstname(name) values('衡')
insert into firstname(name) values('蘅')
insert into firstname(name) values('弘')
insert into firstname(name) values('红')
insert into firstname(name) values('宏')
insert into firstname(name) values('泓')
insert into firstname(name) values('虹')
insert into firstname(name) values('洪')
insert into firstname(name) values('鸿')
insert into firstname(name) values('厚')
insert into firstname(name) values('胡')
insert into firstname(name) values('葫')
insert into firstname(name) values('湖')
insert into firstname(name) values('糊')
insert into firstname(name) values('虎')
insert into firstname(name) values('华')
insert into firstname(name) values('骅')
insert into firstname(name) values('铧')
insert into firstname(name) values('化')
insert into firstname(name) values('画')
insert into firstname(name) values('桦')
insert into firstname(name) values('怀')
insert into firstname(name) values('淮')
insert into firstname(name) values('槐')
insert into firstname(name) values('欢')
insert into firstname(name) values('环')
insert into firstname(name) values('寰')
insert into firstname(name) values('鬟')
insert into firstname(name) values('幻')
insert into firstname(name) values('奂')
insert into firstname(name) values('焕')
insert into firstname(name) values('皇')
insert into firstname(name) values('煌')
insert into firstname(name) values('挥')
insert into firstname(name) values('珲')
insert into firstname(name) values('晖')
insert into firstname(name) values('辉')
insert into firstname(name) values('卉')
insert into firstname(name) values('汇')
insert into firstname(name) values('会')
insert into firstname(name) values('绘')
insert into firstname(name) values('烩')
insert into firstname(name) values('惠')
insert into firstname(name) values('慧')
insert into firstname(name) values('火')
insert into firstname(name) values('伙')
insert into firstname(name) values('惑')
insert into firstname(name) values('霍')
insert into firstname(name) values('姬')
insert into firstname(name) values('基')
insert into firstname(name) values('吉')
insert into firstname(name) values('极')
insert into firstname(name) values('佶')
insert into firstname(name) values('棘')
insert into firstname(name) values('集')
insert into firstname(name) values('藉')
insert into firstname(name) values('籍')
insert into firstname(name) values('纪')
insert into firstname(name) values('季')
insert into firstname(name) values('济')
insert into firstname(name) values('继')
insert into firstname(name) values('寄')
insert into firstname(name) values('霁')
insert into firstname(name) values('鲚')
insert into firstname(name) values('冀')
insert into firstname(name) values('骥')
insert into firstname(name) values('加')
insert into firstname(name) values('佳')
insert into firstname(name) values('迦')
insert into firstname(name) values('珈')
insert into firstname(name) values('枷')
insert into firstname(name) values('家')
insert into firstname(name) values('葭')
insert into firstname(name) values('嘉')
insert into firstname(name) values('甲')
insert into firstname(name) values('稼')
insert into firstname(name) values('坚')
insert into firstname(name) values('柬')
insert into firstname(name) values('俭')
insert into firstname(name) values('简')
insert into firstname(name) values('建')
insert into firstname(name) values('剑')
insert into firstname(name) values('健')
insert into firstname(name) values('鉴')
insert into firstname(name) values('键')
insert into firstname(name) values('箭')
insert into firstname(name) values('江')
insert into firstname(name) values('疆')
insert into firstname(name) values('奖')
insert into firstname(name) values('娇')
insert into firstname(name) values('姣')
insert into firstname(name) values('骄')
insert into firstname(name) values('蛟')
insert into firstname(name) values('觉')
insert into firstname(name) values('教')
insert into firstname(name) values('皆')
insert into firstname(name) values('节')
insert into firstname(name) values('杰')
insert into firstname(name) values('洁')
insert into firstname(name) values('捷')
insert into firstname(name) values('婕')
insert into firstname(name) values('颉')
insert into firstname(name) values('巾')
insert into firstname(name) values('金')
insert into firstname(name) values('津')
insert into firstname(name) values('锦')
insert into firstname(name) values('谨')
insert into firstname(name) values('瑾')
insert into firstname(name) values('槿')
insert into firstname(name) values('进')
insert into firstname(name) values('妗')
insert into firstname(name) values('劲')
insert into firstname(name) values('晋')
insert into firstname(name) values('缙')
insert into firstname(name) values('京')
insert into firstname(name) values('经')
insert into firstname(name) values('菁')
insert into firstname(name) values('旌')
insert into firstname(name) values('惊')
insert into firstname(name) values('晶')
insert into firstname(name) values('精')
insert into firstname(name) values('鲸')
insert into firstname(name) values('井')
insert into firstname(name) values('景')
insert into firstname(name) values('憬')
insert into firstname(name) values('警')
insert into firstname(name) values('净')
insert into firstname(name) values('竞')
insert into firstname(name) values('竟')
insert into firstname(name) values('敬')
insert into firstname(name) values('靖')
insert into firstname(name) values('静')
insert into firstname(name) values('境')
insert into firstname(name) values('镜')
insert into firstname(name) values('炯')
insert into firstname(name) values('九')
insert into firstname(name) values('久')
insert into firstname(name) values('驹')
insert into firstname(name) values('掬')
insert into firstname(name) values('菊')
insert into firstname(name) values('举')
insert into firstname(name) values('炬')
insert into firstname(name) values('锯')
insert into firstname(name) values('聚')
insert into firstname(name) values('娟')
insert into firstname(name) values('珏')
insert into firstname(name) values('崛')
insert into firstname(name) values('军')
insert into firstname(name) values('均')
insert into firstname(name) values('君')
insert into firstname(name) values('钧')
insert into firstname(name) values('筠')
insert into firstname(name) values('俊')
insert into firstname(name) values('郡')
insert into firstname(name) values('峻')
insert into firstname(name) values('浚')
insert into firstname(name) values('骏')
insert into firstname(name) values('珺')
insert into firstname(name) values('竣')
insert into firstname(name) values('开')
insert into firstname(name) values('凯')
insert into firstname(name) values('恺')
insert into firstname(name) values('慨')
insert into firstname(name) values('康')
insert into firstname(name) values('抗')
insert into firstname(name) values('苛')
insert into firstname(name) values('珂')
insert into firstname(name) values('柯')
insert into firstname(name) values('轲')
insert into firstname(name) values('科')
insert into firstname(name) values('可')
insert into firstname(name) values('克')
insert into firstname(name) values('刻')
insert into firstname(name) values('恪')
insert into firstname(name) values('空')
insert into firstname(name) values('宽')
insert into firstname(name) values('旷')
insert into firstname(name) values('奎')
insert into firstname(name) values('逵')
insert into firstname(name) values('葵')
insert into firstname(name) values('魁')
insert into firstname(name) values('坤')
insert into firstname(name) values('昆')
insert into firstname(name) values('琨')
insert into firstname(name) values('焜')
insert into firstname(name) values('鹍')
insert into firstname(name) values('锟')
insert into firstname(name) values('鲲')
insert into firstname(name) values('阔')
insert into firstname(name) values('腊')
insert into firstname(name) values('来')
insert into firstname(name) values('兰')
insert into firstname(name) values('岚')
insert into firstname(name) values('栏')
insert into firstname(name) values('阑')
insert into firstname(name) values('蓝')
insert into firstname(name) values('谰')
insert into firstname(name) values('澜')
insert into firstname(name) values('篮')
insert into firstname(name) values('斓')
insert into firstname(name) values('览')
insert into firstname(name) values('揽')
insert into firstname(name) values('缆')
insert into firstname(name) values('郎')
insert into firstname(name) values('琅')
insert into firstname(name) values('朗')
insert into firstname(name) values('老')
insert into firstname(name) values('乐')
insert into firstname(name) values('雷')
insert into firstname(name) values('镭')
insert into firstname(name) values('耒')
insert into firstname(name) values('磊')
insert into firstname(name) values('蕾')
insert into firstname(name) values('冷')
insert into firstname(name) values('离')
insert into firstname(name) values('骊')
insert into firstname(name) values('梨')
insert into firstname(name) values('鹂')
insert into firstname(name) values('璃')
insert into firstname(name) values('黎')
insert into firstname(name) values('篱')
insert into firstname(name) values('礼')
insert into firstname(name) values('李')
insert into firstname(name) values('里')
insert into firstname(name) values('理')
insert into firstname(name) values('醴')
insert into firstname(name) values('力')
insert into firstname(name) values('立')
insert into firstname(name) values('吏')
insert into firstname(name) values('丽')
insert into firstname(name) values('励')
insert into firstname(name) values('利')
insert into firstname(name) values('荔')
insert into firstname(name) values('栎')
insert into firstname(name) values('郦')
insert into firstname(name) values('俪')
insert into firstname(name) values('俐')
insert into firstname(name) values('莉')
insert into firstname(name) values('笠')
insert into firstname(name) values('跞')
insert into firstname(name) values('傈')
insert into firstname(name) values('连')
insert into firstname(name) values('怜')
insert into firstname(name) values('莲')
insert into firstname(name) values('联')
insert into firstname(name) values('廉')
insert into firstname(name) values('蔹')
insert into firstname(name) values('炼')
insert into firstname(name) values('恋')
insert into firstname(name) values('楝')
insert into firstname(name) values('潋')
insert into firstname(name) values('良')
insert into firstname(name) values('梁')
insert into firstname(name) values('粱')
insert into firstname(name) values('亮')
insert into firstname(name) values('靓')
insert into firstname(name) values('量')
insert into firstname(name) values('尥')
insert into firstname(name) values('林')
insert into firstname(name) values('临')
insert into firstname(name) values('淋')
insert into firstname(name) values('琳')
insert into firstname(name) values('霖')
insert into firstname(name) values('麟')
insert into firstname(name) values('伶')
insert into firstname(name) values('灵')
insert into firstname(name) values('苓')
insert into firstname(name) values('泠')
insert into firstname(name) values('玲')
insert into firstname(name) values('铃')
insert into firstname(name) values('凌')
insert into firstname(name) values('聆')
insert into firstname(name) values('菱')
insert into firstname(name) values('棂')
insert into firstname(name) values('岭')
insert into firstname(name) values('领')
insert into firstname(name) values('令')
insert into firstname(name) values('留')
insert into firstname(name) values('琉')
insert into firstname(name) values('柳')
insert into firstname(name) values('六')
insert into firstname(name) values('龙')
insert into firstname(name) values('泷')
insert into firstname(name) values('珑')
insert into firstname(name) values('栊')
insert into firstname(name) values('隆')
insert into firstname(name) values('颅')
insert into firstname(name) values('鲁')
insert into firstname(name) values('陆')
insert into firstname(name) values('录')
insert into firstname(name) values('逯')
insert into firstname(name) values('禄')
insert into firstname(name) values('路')
insert into firstname(name) values('潞')
insert into firstname(name) values('璐')
insert into firstname(name) values('鹭')
insert into firstname(name) values('露')
insert into firstname(name) values('鸾')
insert into firstname(name) values('銮')
insert into firstname(name) values('乱')
insert into firstname(name) values('仑')
insert into firstname(name) values('伦')
insert into firstname(name) values('纶')
insert into firstname(name) values('轮')
insert into firstname(name) values('罗')
insert into firstname(name) values('萝')
insert into firstname(name) values('倮')
insert into firstname(name) values('泺')
insert into firstname(name) values('洛')
insert into firstname(name) values('侣')
insert into firstname(name) values('律')
insert into firstname(name) values('率')
insert into firstname(name) values('绿')
insert into firstname(name) values('略')
insert into firstname(name) values('玛')
insert into firstname(name) values('蚂')
insert into firstname(name) values('迈')
insert into firstname(name) values('麦')
insert into firstname(name) values('瞒')
insert into firstname(name) values('满')
insert into firstname(name) values('曼')
insert into firstname(name) values('蔓')
insert into firstname(name) values('幔')
insert into firstname(name) values('漫')
insert into firstname(name) values('慢')
insert into firstname(name) values('莽')
insert into firstname(name) values('猫')
insert into firstname(name) values('卯')
insert into firstname(name) values('昴')
insert into firstname(name) values('茂')
insert into firstname(name) values('冒')
insert into firstname(name) values('貌')
insert into firstname(name) values('懋')
insert into firstname(name) values('玫')
insert into firstname(name) values('枚')
insert into firstname(name) values('眉')
insert into firstname(name) values('莓')
insert into firstname(name) values('梅')
insert into firstname(name) values('湄')
insert into firstname(name) values('楣')
insert into firstname(name) values('鹛')
insert into firstname(name) values('美')
insert into firstname(name) values('渼')
insert into firstname(name) values('妹')
insert into firstname(name) values('媚')
insert into firstname(name) values('萌')
insert into firstname(name) values('蒙')
insert into firstname(name) values('盟')
insert into firstname(name) values('猛')
insert into firstname(name) values('孟')
insert into firstname(name) values('梦')
insert into firstname(name) values('米')
insert into firstname(name) values('觅')
insert into firstname(name) values('宓')
insert into firstname(name) values('秘')
insert into firstname(name) values('密')
insert into firstname(name) values('蜜')
insert into firstname(name) values('绵')
insert into firstname(name) values('苗')
insert into firstname(name) values('秒')
insert into firstname(name) values('淼')
insert into firstname(name) values('渺')
insert into firstname(name) values('缈')
insert into firstname(name) values('邈')
insert into firstname(name) values('妙')
insert into firstname(name) values('民')
insert into firstname(name) values('玟')
insert into firstname(name) values('旻')
insert into firstname(name) values('岷')
insert into firstname(name) values('珉')
insert into firstname(name) values('闽')
insert into firstname(name) values('敏')
insert into firstname(name) values('名')
insert into firstname(name) values('明')
insert into firstname(name) values('鸣')
insert into firstname(name) values('茗')
insert into firstname(name) values('铭')
insert into firstname(name) values('酩')
insert into firstname(name) values('沫')
insert into firstname(name) values('蓦')
insert into firstname(name) values('漠')
insert into firstname(name) values('墨')
insert into firstname(name) values('默')
insert into firstname(name) values('谋')
insert into firstname(name) values('木')
insert into firstname(name) values('沐')
insert into firstname(name) values('牧')
insert into firstname(name) values('慕')
insert into firstname(name) values('那')
insert into firstname(name) values('纳')
insert into firstname(name) values('娜')
insert into firstname(name) values('乃')
insert into firstname(name) values('耐')
insert into firstname(name) values('鼐')
insert into firstname(name) values('男')
insert into firstname(name) values('南')
insert into firstname(name) values('楠')
insert into firstname(name) values('腩')
insert into firstname(name) values('能')
insert into firstname(name) values('尼')
insert into firstname(name) values('旎')
insert into firstname(name) values('年')
insert into firstname(name) values('廿')
insert into firstname(name) values('念')
insert into firstname(name) values('乜')
insert into firstname(name) values('宁')
insert into firstname(name) values('柠')
insert into firstname(name) values('聍')
insert into firstname(name) values('凝')
insert into firstname(name) values('泞')
insert into firstname(name) values('农')
insert into firstname(name) values('诺')
insert into firstname(name) values('女')
insert into firstname(name) values('欧')
insert into firstname(name) values('鸥')
insert into firstname(name) values('排')
insert into firstname(name) values('湃')
insert into firstname(name) values('磐')
insert into firstname(name) values('盼')
insert into firstname(name) values('培')
insert into firstname(name) values('沛')
insert into firstname(name) values('佩')
insert into firstname(name) values('霈')
insert into firstname(name) values('芃')
insert into firstname(name) values('朋')
insert into firstname(name) values('彭')
insert into firstname(name) values('鹏')
insert into firstname(name) values('澎')
insert into firstname(name) values('芘')
insert into firstname(name) values('圮')
insert into firstname(name) values('飘')
insert into firstname(name) values('品')
insert into firstname(name) values('聘')
insert into firstname(name) values('乒')
insert into firstname(name) values('娉')
insert into firstname(name) values('平')
insert into firstname(name) values('评')
insert into firstname(name) values('坪')
insert into firstname(name) values('苹')
insert into firstname(name) values('凭')
insert into firstname(name) values('屏')
insert into firstname(name) values('瓶')
insert into firstname(name) values('萍')
insert into firstname(name) values('坡')
insert into firstname(name) values('魄')
insert into firstname(name) values('莆')
insert into firstname(name) values('璞')
insert into firstname(name) values('濮')
insert into firstname(name) values('朴')
insert into firstname(name) values('浦')
insert into firstname(name) values('溥')
insert into firstname(name) values('七')
insert into firstname(name) values('栖')
insert into firstname(name) values('期')
insert into firstname(name) values('亓')
insert into firstname(name) values('齐')
insert into firstname(name) values('祁')
insert into firstname(name) values('岐')
insert into firstname(name) values('其')
insert into firstname(name) values('奇')
insert into firstname(name) values('祈')
insert into firstname(name) values('颀')
insert into firstname(name) values('萁')
insert into firstname(name) values('崎')
insert into firstname(name) values('淇')
insert into firstname(name) values('骐')
insert into firstname(name) values('琪')
insert into firstname(name) values('琦')
insert into firstname(name) values('棋')
insert into firstname(name) values('祺')
insert into firstname(name) values('旗')
insert into firstname(name) values('麒')
insert into firstname(name) values('屺')
insert into firstname(name) values('杞')
insert into firstname(name) values('启')
insert into firstname(name) values('起')
insert into firstname(name) values('绮')
insert into firstname(name) values('气')
insert into firstname(name) values('器')
insert into firstname(name) values('千')
insert into firstname(name) values('芊')
insert into firstname(name) values('谦')
insert into firstname(name) values('前')
insert into firstname(name) values('乾')
insert into firstname(name) values('黔')
insert into firstname(name) values('茜')
insert into firstname(name) values('倩')
insert into firstname(name) values('强')
insert into firstname(name) values('羟')
insert into firstname(name) values('镪')
insert into firstname(name) values('桥')
insert into firstname(name) values('樵')
insert into firstname(name) values('巧')
insert into firstname(name) values('翘')
insert into firstname(name) values('茄')
insert into firstname(name) values('惬')
insert into firstname(name) values('锲')
insert into firstname(name) values('钦')
insert into firstname(name) values('芹')
insert into firstname(name) values('秦')
insert into firstname(name) values('琴')
insert into firstname(name) values('勤')
insert into firstname(name) values('沁')
insert into firstname(name) values('青')
insert into firstname(name) values('卿')
insert into firstname(name) values('清')
insert into firstname(name) values('鲭')
insert into firstname(name) values('情')
insert into firstname(name) values('晴')
insert into firstname(name) values('庆')
insert into firstname(name) values('箐')
insert into firstname(name) values('罄')
insert into firstname(name) values('穹')
insert into firstname(name) values('琼')
insert into firstname(name) values('邱')
insert into firstname(name) values('秋')
insert into firstname(name) values('湫')
insert into firstname(name) values('求')
insert into firstname(name) values('球')
insert into firstname(name) values('裘')
insert into firstname(name) values('渠')
insert into firstname(name) values('曲')
insert into firstname(name) values('权')
insert into firstname(name) values('全')
insert into firstname(name) values('泉')
insert into firstname(name) values('群')
insert into firstname(name) values('然')
insert into firstname(name) values('燃')
insert into firstname(name) values('冉')
insert into firstname(name) values('苒')
insert into firstname(name) values('穰')
insert into firstname(name) values('壤')
insert into firstname(name) values('让')
insert into firstname(name) values('热')
insert into firstname(name) values('人')
insert into firstname(name) values('仁')
insert into firstname(name) values('忍')
insert into firstname(name) values('任')
insert into firstname(name) values('日')
insert into firstname(name) values('荣')
insert into firstname(name) values('容')
insert into firstname(name) values('蓉')
insert into firstname(name) values('榕')
insert into firstname(name) values('融')
insert into firstname(name) values('柔')
insert into firstname(name) values('糅')
insert into firstname(name) values('如')
insert into firstname(name) values('儒')
insert into firstname(name) values('孺')
insert into firstname(name) values('入')
insert into firstname(name) values('朊')
insert into firstname(name) values('蕊')
insert into firstname(name) values('芮')
insert into firstname(name) values('锐')
insert into firstname(name) values('瑞')
insert into firstname(name) values('睿')
insert into firstname(name) values('闰')
insert into firstname(name) values('润')
insert into firstname(name) values('若')
insert into firstname(name) values('偌')
insert into firstname(name) values('三')
insert into firstname(name) values('彡')
insert into firstname(name) values('骚')
insert into firstname(name) values('森')
insert into firstname(name) values('沙')
insert into firstname(name) values('莎')
insert into firstname(name) values('山')
insert into firstname(name) values('姗')
insert into firstname(name) values('珊')
insert into firstname(name) values('善')
insert into firstname(name) values('赡')
insert into firstname(name) values('上')
insert into firstname(name) values('尚')
insert into firstname(name) values('韶')
insert into firstname(name) values('少')
insert into firstname(name) values('邵')
insert into firstname(name) values('绍')
insert into firstname(name) values('舍')
insert into firstname(name) values('社')
insert into firstname(name) values('涉')
insert into firstname(name) values('申')
insert into firstname(name) values('伸')
insert into firstname(name) values('绅')
insert into firstname(name) values('珅')
insert into firstname(name) values('莘')
insert into firstname(name) values('深')
insert into firstname(name) values('燊')
insert into firstname(name) values('沈')
insert into firstname(name) values('慎')
insert into firstname(name) values('升')
insert into firstname(name) values('生')
insert into firstname(name) values('声')
insert into firstname(name) values('笙')
insert into firstname(name) values('省')
insert into firstname(name) values('圣')
insert into firstname(name) values('胜')
insert into firstname(name) values('晟')
insert into firstname(name) values('盛')
insert into firstname(name) values('师')
insert into firstname(name) values('诗')
insert into firstname(name) values('施')
insert into firstname(name) values('十')
insert into firstname(name) values('石')
insert into firstname(name) values('时')
insert into firstname(name) values('识')
insert into firstname(name) values('实')
insert into firstname(name) values('史')
insert into firstname(name) values('矢')
insert into firstname(name) values('士')
insert into firstname(name) values('示')
insert into firstname(name) values('世')
insert into firstname(name) values('仕')
insert into firstname(name) values('事')
insert into firstname(name) values('柿')
insert into firstname(name) values('是')
insert into firstname(name) values('适')
insert into firstname(name) values('释')
insert into firstname(name) values('谥')
insert into firstname(name) values('首')
insert into firstname(name) values('寿')
insert into firstname(name) values('书')
insert into firstname(name) values('枢')
insert into firstname(name) values('姝')
insert into firstname(name) values('殊')
insert into firstname(name) values('淑')
insert into firstname(name) values('舒')
insert into firstname(name) values('曙')
insert into firstname(name) values('术')
insert into firstname(name) values('树')
insert into firstname(name) values('澍')
insert into firstname(name) values('帅')
insert into firstname(name) values('双')
insert into firstname(name) values('霜')
insert into firstname(name) values('爽')
insert into firstname(name) values('水')
insert into firstname(name) values('顺')
insert into firstname(name) values('舜')
insert into firstname(name) values('烁')
insert into firstname(name) values('铄')
insert into firstname(name) values('朔')
insert into firstname(name) values('硕')
insert into firstname(name) values('厶')
insert into firstname(name) values('司')
insert into firstname(name) values('丝')
insert into firstname(name) values('思')
insert into firstname(name) values('鸶')
insert into firstname(name) values('斯')
insert into firstname(name) values('偲')
insert into firstname(name) values('四')
insert into firstname(name) values('嗣')
insert into firstname(name) values('松')
insert into firstname(name) values('菘')
insert into firstname(name) values('淞')
insert into firstname(name) values('颂')
insert into firstname(name) values('苏')
insert into firstname(name) values('夙')
insert into firstname(name) values('素')
insert into firstname(name) values('邃')
insert into firstname(name) values('孙')
insert into firstname(name) values('锁')
insert into firstname(name) values('太')
insert into firstname(name) values('泰')
insert into firstname(name) values('坛')
insert into firstname(name) values('堂')
insert into firstname(name) values('棠')
insert into firstname(name) values('涛')
insert into firstname(name) values('滔')
insert into firstname(name) values('韬')
insert into firstname(name) values('饕')
insert into firstname(name) values('逃')
insert into firstname(name) values('桃')
insert into firstname(name) values('陶')
insert into firstname(name) values('淘')
insert into firstname(name) values('腾')
insert into firstname(name) values('体')
insert into firstname(name) values('悌')
insert into firstname(name) values('惕')
insert into firstname(name) values('天')
insert into firstname(name) values('添')
insert into firstname(name) values('田')
insert into firstname(name) values('恬')
insert into firstname(name) values('甜')
insert into firstname(name) values('湉')
insert into firstname(name) values('舔')
insert into firstname(name) values('铁')
insert into firstname(name) values('厅')
insert into firstname(name) values('汀')
insert into firstname(name) values('听')
insert into firstname(name) values('廷')
insert into firstname(name) values('亭')
insert into firstname(name) values('庭')
insert into firstname(name) values('停')
insert into firstname(name) values('婷')
insert into firstname(name) values('珽')
insert into firstname(name) values('通')
insert into firstname(name) values('同')
insert into firstname(name) values('彤')
insert into firstname(name) values('桐')
insert into firstname(name) values('铜')
insert into firstname(name) values('童')
insert into firstname(name) values('潼')
insert into firstname(name) values('瞳')
insert into firstname(name) values('统')
insert into firstname(name) values('图')
insert into firstname(name) values('涂')
insert into firstname(name) values('土')
insert into firstname(name) values('拓')
insert into firstname(name) values('娃')
insert into firstname(name) values('湾')
insert into firstname(name) values('纨')
insert into firstname(name) values('宛')
insert into firstname(name) values('菀')
insert into firstname(name) values('婉')
insert into firstname(name) values('琬')
insert into firstname(name) values('万')
insert into firstname(name) values('汪')
insert into firstname(name) values('枉')
insert into firstname(name) values('旺')
insert into firstname(name) values('望')
insert into firstname(name) values('威')
insert into firstname(name) values('逶')
insert into firstname(name) values('葳')
insert into firstname(name) values('薇')
insert into firstname(name) values('巍')
insert into firstname(name) values('韦')
insert into firstname(name) values('为')
insert into firstname(name) values('唯')
insert into firstname(name) values('惟')
insert into firstname(name) values('维')
insert into firstname(name) values('潍')
insert into firstname(name) values('伟')
insert into firstname(name) values('苇')
insert into firstname(name) values('纬')
insert into firstname(name) values('玮')
insert into firstname(name) values('委')
insert into firstname(name) values('炜')
insert into firstname(name) values('韪')
insert into firstname(name) values('卫')
insert into firstname(name) values('未')
insert into firstname(name) values('位')
insert into firstname(name) values('尉')
insert into firstname(name) values('渭')
insert into firstname(name) values('蔚')
insert into firstname(name) values('慰')
insert into firstname(name) values('魏')
insert into firstname(name) values('温')
insert into firstname(name) values('文')
insert into firstname(name) values('纹')
insert into firstname(name) values('闻')
insert into firstname(name) values('雯')
insert into firstname(name) values('稳')
insert into firstname(name) values('问')
insert into firstname(name) values('汶')
insert into firstname(name) values('沃')
insert into firstname(name) values('乌')
insert into firstname(name) values('吾')
insert into firstname(name) values('吴')
insert into firstname(name) values('梧')
insert into firstname(name) values('五')
insert into firstname(name) values('伍')
insert into firstname(name) values('武')
insert into firstname(name) values('悟')
insert into firstname(name) values('晤')
insert into firstname(name) values('夕')
insert into firstname(name) values('兮')
insert into firstname(name) values('西')
insert into firstname(name) values('汐')
insert into firstname(name) values('希')
insert into firstname(name) values('昔')
insert into firstname(name) values('析')
insert into firstname(name) values('唏')
insert into firstname(name) values('晞')
insert into firstname(name) values('淅')
insert into firstname(name) values('惜')
insert into firstname(name) values('晰')
insert into firstname(name) values('稀')
insert into firstname(name) values('锡')
insert into firstname(name) values('溪')
insert into firstname(name) values('熙')
insert into firstname(name) values('熹')
insert into firstname(name) values('羲')
insert into firstname(name) values('曦')
insert into firstname(name) values('习')
insert into firstname(name) values('玺')
insert into firstname(name) values('铣')
insert into firstname(name) values('喜')
insert into firstname(name) values('葸')
insert into firstname(name) values('禧')
insert into firstname(name) values('细')
insert into firstname(name) values('侠')
insert into firstname(name) values('遐')
insert into firstname(name) values('霞')
insert into firstname(name) values('下')
insert into firstname(name) values('夏')
insert into firstname(name) values('仙')
insert into firstname(name) values('先')
insert into firstname(name) values('纤')
insert into firstname(name) values('贤')
insert into firstname(name) values('弦')
insert into firstname(name) values('娴')
insert into firstname(name) values('显')
insert into firstname(name) values('现')
insert into firstname(name) values('宪')
insert into firstname(name) values('羡')
insert into firstname(name) values('献')
insert into firstname(name) values('乡')
insert into firstname(name) values('相')
insert into firstname(name) values('香')
insert into firstname(name) values('湘')
insert into firstname(name) values('镶')
insert into firstname(name) values('详')
insert into firstname(name) values('祥')
insert into firstname(name) values('翔')
insert into firstname(name) values('想')
insert into firstname(name) values('向')
insert into firstname(name) values('项')
insert into firstname(name) values('肖')
insert into firstname(name) values('骁')
insert into firstname(name) values('萧')
insert into firstname(name) values('箫')
insert into firstname(name) values('潇')
insert into firstname(name) values('霄')
insert into firstname(name) values('小')
insert into firstname(name) values('晓')
insert into firstname(name) values('筱')
insert into firstname(name) values('孝')
insert into firstname(name) values('哮')
insert into firstname(name) values('笑')
insert into firstname(name) values('效')
insert into firstname(name) values('心')
insert into firstname(name) values('芯')
insert into firstname(name) values('辛')
insert into firstname(name) values('忻')
insert into firstname(name) values('昕')
insert into firstname(name) values('欣')
insert into firstname(name) values('新')
insert into firstname(name) values('歆')
insert into firstname(name) values('馨')
insert into firstname(name) values('鑫')
insert into firstname(name) values('信')
insert into firstname(name) values('星')
insert into firstname(name) values('兴')
insert into firstname(name) values('杏')
insert into firstname(name) values('幸')
insert into firstname(name) values('婞')
insert into firstname(name) values('雄')
insert into firstname(name) values('修')
insert into firstname(name) values('秀')
insert into firstname(name) values('戌')
insert into firstname(name) values('许')
insert into firstname(name) values('栩')
insert into firstname(name) values('旭')
insert into firstname(name) values('序')
insert into firstname(name) values('叙')
insert into firstname(name) values('绪')
insert into firstname(name) values('续')
insert into firstname(name) values('蓄')
insert into firstname(name) values('煦')
insert into firstname(name) values('轩')
insert into firstname(name) values('宣')
insert into firstname(name) values('萱')
insert into firstname(name) values('暄')
insert into firstname(name) values('煊')
insert into firstname(name) values('玄')
insert into firstname(name) values('旋')
insert into firstname(name) values('漩')
insert into firstname(name) values('璇')
insert into firstname(name) values('选')
insert into firstname(name) values('烜')
insert into firstname(name) values('泫')
insert into firstname(name) values('炫')
insert into firstname(name) values('绚')
insert into firstname(name) values('铉')
insert into firstname(name) values('渲')
insert into firstname(name) values('碹')
insert into firstname(name) values('学')
insert into firstname(name) values('雪')
insert into firstname(name) values('勋')
insert into firstname(name) values('寻')
insert into firstname(name) values('荀')
insert into firstname(name) values('训')
insert into firstname(name) values('雅')
insert into firstname(name) values('亚')
insert into firstname(name) values('娅')
insert into firstname(name) values('烟')
insert into firstname(name) values('延')
insert into firstname(name) values('严')
insert into firstname(name) values('言')
insert into firstname(name) values('妍')
insert into firstname(name) values('岩')
insert into firstname(name) values('炎')
insert into firstname(name) values('研')
insert into firstname(name) values('盐')
insert into firstname(name) values('颜')
insert into firstname(name) values('衍')
insert into firstname(name) values('琰')
insert into firstname(name) values('砚')
insert into firstname(name) values('彦')
insert into firstname(name) values('艳')
insert into firstname(name) values('晏')
insert into firstname(name) values('雁')
insert into firstname(name) values('焰')
insert into firstname(name) values('焱')
insert into firstname(name) values('滟')
insert into firstname(name) values('燕')
insert into firstname(name) values('央')
insert into firstname(name) values('扬')
insert into firstname(name) values('阳')
insert into firstname(name) values('玚')
insert into firstname(name) values('杨')
insert into firstname(name) values('旸')
insert into firstname(name) values('徉')
insert into firstname(name) values('洋')
insert into firstname(name) values('烊')
insert into firstname(name) values('尧')
insert into firstname(name) values('肴')
insert into firstname(name) values('垚')
insert into firstname(name) values('姚')
insert into firstname(name) values('珧')
insert into firstname(name) values('遥')
insert into firstname(name) values('瑶')
insert into firstname(name) values('钥')
insert into firstname(name) values('曜')
insert into firstname(name) values('耀')
insert into firstname(name) values('野')
insert into firstname(name) values('业')
insert into firstname(name) values('叶')
insert into firstname(name) values('页')
insert into firstname(name) values('邺')
insert into firstname(name) values('夜')
insert into firstname(name) values('晔')
insert into firstname(name) values('烨')
insert into firstname(name) values('一')
insert into firstname(name) values('伊')
insert into firstname(name) values('依')
insert into firstname(name) values('祎')
insert into firstname(name) values('漪')
insert into firstname(name) values('仪')
insert into firstname(name) values('饴')
insert into firstname(name) values('怡')
insert into firstname(name) values('宜')
insert into firstname(name) values('颐')
insert into firstname(name) values('乙')
insert into firstname(name) values('以')
insert into firstname(name) values('苡')
insert into firstname(name) values('迤')
insert into firstname(name) values('倚')
insert into firstname(name) values('弋')
insert into firstname(name) values('义')
insert into firstname(name) values('艺')
insert into firstname(name) values('忆')
insert into firstname(name) values('屹')
insert into firstname(name) values('亦')
insert into firstname(name) values('邑')
insert into firstname(name) values('佚')
insert into firstname(name) values('译')
insert into firstname(name) values('易')
insert into firstname(name) values('峄')
insert into firstname(name) values('怿')
insert into firstname(name) values('驿')
insert into firstname(name) values('弈')
insert into firstname(name) values('奕')
insert into firstname(name) values('羿')
insert into firstname(name) values('挹')
insert into firstname(name) values('益')
insert into firstname(name) values('谊')
insert into firstname(name) values('逸')
insert into firstname(name) values('意')
insert into firstname(name) values('缢')
insert into firstname(name) values('毅')
insert into firstname(name) values('熠')
insert into firstname(name) values('翼')
insert into firstname(name) values('懿')
insert into firstname(name) values('茵')
insert into firstname(name) values('荫')
insert into firstname(name) values('音')
insert into firstname(name) values('姻')
insert into firstname(name) values('吟')
insert into firstname(name) values('银')
insert into firstname(name) values('印')
insert into firstname(name) values('胤')
insert into firstname(name) values('英')
insert into firstname(name) values('莺')
insert into firstname(name) values('罂')
insert into firstname(name) values('缨')
insert into firstname(name) values('樱')
insert into firstname(name) values('迎')
insert into firstname(name) values('盈')
insert into firstname(name) values('营')
insert into firstname(name) values('滢')
insert into firstname(name) values('嬴')
insert into firstname(name) values('颖')
insert into firstname(name) values('影')
insert into firstname(name) values('映')
insert into firstname(name) values('庸')
insert into firstname(name) values('雍')
insert into firstname(name) values('永')
insert into firstname(name) values('咏')
insert into firstname(name) values('泳')
insert into firstname(name) values('勇')
insert into firstname(name) values('用')
insert into firstname(name) values('攸')
insert into firstname(name) values('忧')
insert into firstname(name) values('尤')
insert into firstname(name) values('游')
insert into firstname(name) values('友')
insert into firstname(name) values('有')
insert into firstname(name) values('又')
insert into firstname(name) values('幼')
insert into firstname(name) values('佑')
insert into firstname(name) values('于')
insert into firstname(name) values('余')
insert into firstname(name) values('妤')
insert into firstname(name) values('鱼')
insert into firstname(name) values('禺')
insert into firstname(name) values('萸')
insert into firstname(name) values('渔')
insert into firstname(name) values('愉')
insert into firstname(name) values('瑜')
insert into firstname(name) values('觎')
insert into firstname(name) values('与')
insert into firstname(name) values('予')
insert into firstname(name) values('屿')
insert into firstname(name) values('宇')
insert into firstname(name) values('羽')
insert into firstname(name) values('雨')
insert into firstname(name) values('禹')
insert into firstname(name) values('语')
insert into firstname(name) values('玉')
insert into firstname(name) values('郁')
insert into firstname(name) values('育')
insert into firstname(name) values('昱')
insert into firstname(name) values('彧')
insert into firstname(name) values('钰')
insert into firstname(name) values('裕')
insert into firstname(name) values('煜')
insert into firstname(name) values('誉')
insert into firstname(name) values('毓')
insert into firstname(name) values('豫')
insert into firstname(name) values('燠')
insert into firstname(name) values('渊')
insert into firstname(name) values('元')
insert into firstname(name) values('芫')
insert into firstname(name) values('园')
insert into firstname(name) values('沅')
insert into firstname(name) values('袁')
insert into firstname(name) values('原')
insert into firstname(name) values('圆')
insert into firstname(name) values('媛')
insert into firstname(name) values('缘')
insert into firstname(name) values('塬')
insert into firstname(name) values('源')
insert into firstname(name) values('辕')
insert into firstname(name) values('橼')
insert into firstname(name) values('远')
insert into firstname(name) values('苑')
insert into firstname(name) values('瑗')
insert into firstname(name) values('愿')
insert into firstname(name) values('月')
insert into firstname(name) values('刖')
insert into firstname(name) values('岳')
insert into firstname(name) values('悦')
insert into firstname(name) values('跃')
insert into firstname(name) values('越')
insert into firstname(name) values('粤')
insert into firstname(name) values('樾')
insert into firstname(name) values('云')
insert into firstname(name) values('匀')
insert into firstname(name) values('芸')
insert into firstname(name) values('妘')
insert into firstname(name) values('昀')
insert into firstname(name) values('耘')
insert into firstname(name) values('允')
insert into firstname(name) values('运')
insert into firstname(name) values('韵')
insert into firstname(name) values('蕴')
insert into firstname(name) values('载')
insert into firstname(name) values('早')
insert into firstname(name) values('藻')
insert into firstname(name) values('泽')
insert into firstname(name) values('增')
insert into firstname(name) values('展')
insert into firstname(name) values('湛')
insert into firstname(name) values('章')
insert into firstname(name) values('彰')
insert into firstname(name) values('璋')
insert into firstname(name) values('樟')
insert into firstname(name) values('长')
insert into firstname(name) values('钊')
insert into firstname(name) values('昭')
insert into firstname(name) values('兆')
insert into firstname(name) values('赵')
insert into firstname(name) values('哲')
insert into firstname(name) values('喆')
insert into firstname(name) values('鹧')
insert into firstname(name) values('贞')
insert into firstname(name) values('珍')
insert into firstname(name) values('真')
insert into firstname(name) values('桢')
insert into firstname(name) values('祯')
insert into firstname(name) values('榛')
insert into firstname(name) values('稹')
insert into firstname(name) values('阵')
insert into firstname(name) values('振')
insert into firstname(name) values('震')
insert into firstname(name) values('征')
insert into firstname(name) values('峥')
insert into firstname(name) values('铮')
insert into firstname(name) values('整')
insert into firstname(name) values('正')
insert into firstname(name) values('政')
insert into firstname(name) values('之')
insert into firstname(name) values('卮')
insert into firstname(name) values('芝')
insert into firstname(name) values('枝')
insert into firstname(name) values('知')
insert into firstname(name) values('栀')
insert into firstname(name) values('芷')
insert into firstname(name) values('志')
insert into firstname(name) values('致')
insert into firstname(name) values('智')
insert into firstname(name) values('中')
insert into firstname(name) values('忠')
insert into firstname(name) values('钟')
insert into firstname(name) values('仲')
insert into firstname(name) values('众')
insert into firstname(name) values('舟')
insert into firstname(name) values('州')
insert into firstname(name) values('周')
insert into firstname(name) values('洲')
insert into firstname(name) values('珠')
insert into firstname(name) values('竹')
insert into firstname(name) values('竺')
insert into firstname(name) values('烛')
insert into firstname(name) values('驻')
insert into firstname(name) values('柱')
insert into firstname(name) values('祝')
insert into firstname(name) values('专')
insert into firstname(name) values('壮')
insert into firstname(name) values('隹')
insert into firstname(name) values('卓')
insert into firstname(name) values('濯')
insert into firstname(name) values('孜')
insert into firstname(name) values('姿')
insert into firstname(name) values('兹')
insert into firstname(name) values('资')
insert into firstname(name) values('子')
insert into firstname(name) values('梓')
insert into firstname(name) values('紫')
insert into firstname(name) values('自')
insert into firstname(name) values('恣')
insert into firstname(name) values('纵')
insert into firstname(name) values('祖')
insert into firstname(name) values('醉')
insert into firstname(name) values('佐')
insert into firstname(name) values('作')

go

declare @lastName varchar(4000)
declare @rndN varchar(4)
declare @i int
declare @i2 int
declare @rndLen int
declare @rndName varchar(8)
declare @k int    --精度
declare @maxId int
set @maxId =(select max(id) from firstname)
set @k=0
set @lastName = '赵钱孙李周吴郑王冯陈诸卫蒋沈韩杨朱秦尤许何吕施张孔曹严华金魏陶姜戚谢邹喻柏水窦章云苏潘葛奚范彭郎鲁韦昌马苗凤花方俞任袁柳酆鲍史唐费廉岑薛雷贺倪汤滕殷罗毕郝邬安常乐于时傅皮卡齐康伍余元卜顾孟平黄和穆萧尹姚邵堪汪祁毛禹狄米贝明臧计伏成戴谈宋茅庞熊纪舒屈项祝董粱杜阮蓝闵席季麻强贾路娄危江童颜郭梅盛林刁钟徐邱骆高夏蔡田樊胡凌霍虞万支柯咎管卢莫经房裘缪干解应宗丁宣贲邓郁单杭洪包诸左石崔吉钮龚程嵇邢滑裴陆荣翁荀羊於惠甄魏家封芮羿储靳汲邴糜松井段富巫乌焦巴弓牧隗山谷车侯宓蓬全郗班仰秋仲伊宫宁仇栾暴甘钭厉戎祖武符刘景詹束龙叶幸司韶郜黎蓟薄印宿白怀蒲台从鄂索咸籍赖卓蔺屠蒙池乔阴郁胥能苍双闻莘党翟谭贡劳逄姬申扶堵冉宰郦雍却璩桑桂濮牛寿通边扈燕冀郏浦尚农温别庄晏柴翟阎充慕连茹习宦艾鱼容向古易慎戈廖庚终暨居衡步都耿满弘匡国文寇广禄阙东殴殳沃利蔚越夔隆师巩厍聂晁勾敖融冷訾辛阚那简饶空曾毋沙乜养鞠须丰巢关蒯相查后荆红游竺权逯盖后桓公万俟司马上官欧阳夏侯诸葛闻人东方赫连皇甫尉迟公羊澹台公冶宗政濮阳淳于单于太叔申屠公孙仲孙轩辕令狐钟离宇文长孙慕容鲜于闾丘司徒司空亓官司寇仉督子车颛孙端木巫马公西漆雕乐正壤驷公良拓拔夹谷宰父谷粱晋楚闫法汝鄢涂钦段干百里东郭南门呼延归海羊舌微生岳帅缑亢况后有琴梁丘左丘东门西门商牟佘佴伯赏南宫墨哈谯笪年爱阳佟'
set @i=0
while @i<=200
begin
    --名字的字数1个或者2个
    set @rndLen = round(rand()*(2-1)+1,@k)
    print @rndLen
    
    --生成随机名字
    set @rndN = ''
    set @i2=0
    while @i2<@rndLen
    begin
        set @rndN = @rndN + (select name from firstname where id = convert(int,round(rand()*(@maxId-0)+0,1)))
        set @i2=@i2+1
    end
    
    --随机姓氏和名字
    set @rndName = substring(@lastName,convert(int,round(rand()*(len(@lastName)-1)+1,@k)),1) 
                + @rndN
    print @rndName
    set @i=@i+1
end
go



本站文章旨在为该问题提供解决思路及关键性代码,并不能完成应该由网友自己完成的所有工作,请网友在仔细看文章并理解思路的基础上举一反三、灵活运用。

access911.net 原创文章,作者本人对文章保留一切权利。
如需转载必须征得作者同意并注明本站链接

 

 
相关文章
     没有手动相关文章
 
评论
     查看或发表更多的评论,请单击这里。
 
 
 
 
 
   
  Access911.net   |   a9BBS   |   OTaA System   |
建站日期:2000年4月2日  |  设计施工:陈格 ( access911 & cg1 )
 Copyright © 2000 - 2003 COMET, 陈格 保留所有权利