呼和浩特sql

Ⅰ 处理数据批量生成sql插入语句

处理数据批量生成sql插入语句
最近在做一个天气预报模块，首先需要将客户端公网ip转换成所在城市，然后将所在城市名转换成对应的城市代码，在网上找到了城市代码，但是需要处理一下，看了看，有三百多城市及对应的城市代码，想存到数据库。就想着做一个数据处理自动生成sql语句的工具，提高效率。
1 直辖市
2 "北京","上海","天津","重庆"
3 "101010100","101020100","101030100","101040100"
4
5 特别行政区
6 "香港","澳门"
7 "101320101","101330101"
8
9 黑龙江
10 "哈尔滨","齐齐哈尔","牡丹江","大庆","伊春","双鸭山","鹤岗","鸡西","佳木斯","七台河","黑河","绥化","大兴安岭"
11 "101050101","101050201","101050301","101050901","101050801","101051301","101051201","101051101","101050401","101051002","101050601","101050501","101050701"
12
13 吉林
14 "长春","延吉","吉林","白山","白城","四平","松原","辽源","大安","通化"
15 "101060101","101060301","101060201","101060901","101060601","101060401","101060801","101060701","101060603","101060501"
16
17 辽宁
18 "沈阳","大连","葫芦岛","盘锦","本溪","抚顺","铁岭","辽阳","营口","阜新","朝阳","锦州","丹东","鞍山"
19 "101070101","101070201","101071401","101071301","101070501","101070401","101071101","101071001","101070801","101070901","101071201","101070701","101070601","101070301"
20
21 内蒙古
22 "呼和浩特","呼伦贝尔","锡林浩特","包头","赤峰","海拉尔","乌海","鄂尔多斯","通辽"
23 "101080101","101081000","101080901","101080201","101080601","101081001","101080301","101080701","101080501"
24
25 河北
26 "石家庄","唐山","张家口","廊坊","邢台","邯郸","沧州","衡水","承德","保定","秦皇岛"
27 "101090101","101090501","101090301","101090601","101090901","101091001","101090701","101090801","101090402","101090201","101091101"
28
29 河南
30 "郑州","开封","洛阳","平顶山","焦作","鹤壁","新乡","安阳","濮阳","许昌","漯河","三门峡","南阳","商丘","信阳","周口","驻马店"
31 "101180101","101180801","101180901","101180501","101181101","101181201","101180301","101180201","101181301","101180401","101181501","101181701","101180701","101181001","101180601","101181401","101181601"
32
33 山东
34 "济南","青岛","淄博","威海","曲阜","临沂","烟台","枣庄","聊城","济宁","菏泽","泰安","日照","东营","德州","滨州","莱芜","潍坊"
35 "101120101","101120201","101120301","101121301","101120710","101120901","101120501","101121401","101121701","101120701","101121001","101120801","101121501","101121201","101120401","101121101","101121601","101120601"
36
37 山西
38 "太原","阳泉","晋城","晋中","临汾","运城","长治","朔州","忻州","大同","吕梁"
39 "101100101","101100301","101100601","101100401","101100701","101100801","101100501","101100901","101101001","101100201","101101101"
40
41 江苏
42 "南京","苏州","昆山","南通","太仓","吴县","徐州","宜兴","镇江","淮安","常熟","盐城","泰州","无锡","连云港","扬州","常州","宿迁"
43 "101190101","101190401","101190404","101190501","101190408","101190406","101190801","101190203","101190301","101190901","101190402","101190701","101191201","101190201","101191001","101190601","101191101","101191301"
44
45 安徽
46 "合肥","巢湖","蚌端口","安庆","六安","滁州","马鞍山","阜阳","宣城","铜陵","淮北","芜湖","毫州","宿州","淮南","池州"
47 "101220101","101221601","101220201","101220601","101221501","101221101","101220501","101220801","101221401","101221301","101221201","101220301","101220901","101220701","101220401","101221701"
48
49 陕西
50 "西安","韩城","安康","汉中","宝鸡","咸阳","榆林","渭南","商洛","铜川","延安"
51 "101110101","101110510","101110701","101110801","101110901","101110200","101110401","101110501","101110601","101111001","101110300"
52
53 宁夏
54 "银川","固原","中卫","石嘴山","吴忠"
55 "101170101","101170401","101170501","101170201","101170301"
56
57 甘肃
58 "兰州","白银","庆阳","酒泉","天水","武威","张掖","甘南","临夏","平凉","定西","金昌"
59 "101160101","101161301","101160401","101160801","101160901","101160501","101160701","101050204","101161101","101160301","101160201","101160601"
60
61 青海
62 "西宁","海北","海西","黄南","果洛","玉树","海东","海南"
63 "101150101","101150801","101150701","101150301","101150501","101150601","101150201","101150401"
64
65 湖北
66 "武汉","宜昌","黄冈","恩施","荆州","神农架","十堰","咸宁","襄阳","孝感","随州","黄石","荆门","鄂州"
67 "101200101","101200901","101200501","101201001","101200801","101201201","101201101","101200701","101200201","101200401","101201301","101200601","101201401","101200301"
68
69 湖南
70 "长沙","邵阳","常德","郴州","吉首","株洲","娄底","湘潭","益阳","永州","岳阳","衡阳","怀化","韶山","张家界"
71 "101250101","101250901","101250601","101250501","101251501","101250301","101250801","101250201","101250701","101251401","101251001","101250401","101251201","101250202","101251101"
72
73 浙江
74 "杭州","湖州","金华","宁波","丽水","绍兴","衢州","嘉兴","台州","舟山","温州"
75 "101210101","101210201","101210901","101210401","101210801","101210501","101211001","101210301","101210601","101211101","101210701"
76
77 江西
78 "南昌","萍乡","九江","上饶","抚州","吉安","鹰潭","宜春","新余","景德镇","赣州"
79 "101240101","101240901","101240201","101240301","101240401","101240601","101241101","101240501","101241001","101240801","101240701"
80
81 福建
82 "福州","厦门","龙岩","南平","宁德","莆田","泉州","三明","漳州"
83 "101230101","101230201","101230701","101230901","101230301","101230401","101230501","101230801","101230601"
84
85 贵州
86 "贵阳","安顺","赤水","遵义","铜仁","六盘水","毕节","凯里","都匀"
87 "101260101","101260301","101260208","101260201","101260601","101260801","101260701","101260501","101260401"
88
89 四川
90 "成都","泸州","内江","凉山","阿坝","巴中","广元","乐山","绵阳","德阳","攀枝花","雅安","宜宾","自贡","甘孜州","达州","资阳","广安","遂宁","眉山","南充"
91 "101270101","101271001","101271201","101271601","101271901","101270901","101272101","101271401","101270401","101272001","101270201","101271701","101271101","101270301","101271801","101270601","101271301","101270801","101270701","101271501","101270501"
92
93 广东
94 "广州","深圳","潮州","韶关","湛江","惠州","清远","东莞","江门","茂名","肇庆","汕尾","河源","揭阳","梅州","中山","德庆","阳江","云浮","珠海","汕头","佛山"
95 "101280101","101280601","101281501","101280201","101281001","101280301","101281301","101281601","101281101","101282001","101280901","101282101","101281201","101281901","101280401","101281701","101280905","101281801","101281401","101280701","101280501","101280800"
96
97 广西
98 "南宁","桂林","阳朔","柳州","梧州","玉林","桂平","贺州","钦州","贵港","防城港","百色","北海","河池","来宾","崇左"
99 "101300101","101300501","101300510","101300301","101300601","101300901","101300802","101300701","101301101","101300801","101301401","101301001","101301301","101301201","101300401","101300201"
100
101 云南
102 "昆明","保山","楚雄","德宏","红河","临沧","怒江","曲靖","思茅","文山","玉溪","昭通","丽江","大理"
103 "101290101","101290501","101290801","101291501","101290301","101291101","101291201","101290401","101290901","101290601","101290701","101291001","101291401","101290201"
104
105 海南
106 "海口","三亚","儋州","琼山","通什","文昌"
107 "101310101","101310201","101310205","101310102","101310222","101310212"
108
109 新疆
110 "乌鲁木齐","阿勒泰","阿克苏","昌吉","哈密","和田","喀什","克拉玛依","石河子","塔城","库尔勒","吐鲁番","伊宁"
111 "101130101","101131401","101130801","101130401","101131201","101131301","101130901","101130201","101130301","101131101","101130601","101130501","101131001"
112
113 西藏
114 "拉萨","阿里","昌都","那曲","日喀则","山南","林芝"
115 "101140101","101140701","101140501","101140601","101140201","101140301","101140401"
116
117 台湾
118 "台北","高雄"
119 "101340102","101340201"

城市代码

一看上去很乱的，而且对应关系是每个省城市一行，代码一行，分别用引号引起，用逗号分隔，每行间都没有符号分隔，省名没有用引号。首先是想着把省名去掉，因为每个城市名都是不相同的。想着每两行两行的去处理，但是也要费不少功夫，还容易出错。就想个索性一次性的全处理的算法。

ps：界面很简单，上面是输入数据，中间是转换，下面是输出数据。

后台主要代码：
[csharp] view plain

private void button1_Click(object sender, EventArgs e)
{
string data = textBox1.Text.Replace("r", "").Replace("n", "").Replace("t", "").Replace(" ", "").Replace(" ", "").Replace(" ", "");
MatchCollection matchsdata = matches(data, ""[sS]*?"");
string[,] temps = new string[matchsdata.Count / 2, 2];
int count0 = 0;
int count1 = 0;
string input = string.Empty;
foreach (Match m in matchsdata)
{
string tempdata = m.Value.Replace(""", "");
try
{
int tryp = int.Parse(tempdata);
temps[count1, 1] = tempdata;
count1++;
}
catch (Exception ex)
{
temps[count0, 0] = tempdata;
count0++;
}
}
for (int i = 0; i < (matchsdata.Count / 2); i++)
{
input += "insert into tbl_CityCode(c_city,c_code) values( + temps[i, 0] + , + temps[i, 1] + )rn";
}
textBox2.Text = input;
}

public static MatchCollection matches(string str, string exp)
{
return Regex.Matches(str, exp, RegexOptions.IgnoreCase);
}

首先是将输入的数据处理，去除换行符，空格什么的。然后你应该是会得到一行数据，然后通过正则表达式匹配出所有带引号的数据，你会发现需要的数据全部都是用引号引起来的，但是怎样区分城市名和城市代码呢，它们是混在一起的。不用担心，你发现了吗？城市名是字符串，城市代码是一串数字，我们只要将匹配出的数据数组遍历，每一行数据都去转换成int类型，这样城市名的行就会报错，在catch中捕捉，这一行就是城市名，没错的就是城市代码，把数据一次存到一个二维数组，对应的列中就行了。这样就会获得了相对应的城市名和城市代码。生成的sql语句要对应相应的数据库表。
表结构：
转换完了将生成的sql语句放到查询器中执行就ok了。共处理了349个城市。
最后不放心自己的算法，随机抽查了几条数据，没有错误。

<script type="text/javascript"><!-- google_ad_client = "ca-pub-1944176156128447"; /* cnblogs 首页横幅 */ google_ad_slot = "5419468456"; google_ad_width = 728; google_ad_height = 90; //--></script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

Ⅱ 呼和浩特大数据培训课程大纲哪里好

你好，大数据基础技术覆盖数据采集、数据预处理、分布式存储、NOSQL数据库、多模式计算（批处理、在线处理、实时流处理、内存处理）、多模态计算（图像、文本、视频、音频）、数据仓库、数据挖掘、机器学习、人工智能、深度学习、并行计算、可视化等各种技术范畴和不同的层面。现在的学习，数据很多内容，魔据大数据简单，容易懂，对于数据的学习，需要认真加上自身的努力。

Ⅲ SQL2005中,创建表的错误,我竟然找半天找不出

use 企业销售管理系统
create table 仓库
(
仓库ID int identity(1,1) primary key,
仓库号 varchar(50) unique,
城市 varchar(50) default '呼和浩特',
面积 int default 800 check(面积>=500 and 面积<=1800),
创建时间 datetime
)

错误原因：默认约束没有默认值

Ⅳ SQL语句inster插入语句

insert
into
表名(对应列名1,对应列名2,...)
values('nmg0001','内蒙古蒙牛乳业集团有限公司',NULL,'呼和浩特市和林格尔县盛乐经济园区','0471-7392222
','生产液态奶、酸奶、冰淇淋、奶品、奶酪'
)

你把表名换成你需要输入数据的表名，对应列名是需要你输入你的值所对应的数据表的相应的字段的名称

Ⅳ 省市二级菜单

<script language=vbScript>
<!--
public x(33)
x( 0 )="东城,西城,崇文,宣武,朝阳,丰台,石景山,海淀,门头沟,房山,通州,顺义,昌平,大兴,平谷,怀柔,密云,延庆"
x( 1 )="黄浦,卢湾,徐汇,长宁,静安,普陀,闸北,虹口,杨浦,闵行,宝山,嘉定,浦东,金山,松江,青浦,南汇,奉贤,崇明"
x( 2 )="和平,东丽,河东,西青,河西,津南,南开,北辰,河北,武清,红挢,塘沽,汉沽,大港,宁河,静海,宝坻,蓟县"
x( 3 )="万州,涪陵,渝中,大渡口,江北,沙坪坝,九龙坡,南岸,北碚,万盛,双挢,渝北,巴南,黔江,长寿,綦江,潼南,铜梁,大足,荣昌,壁山,梁平,城口,丰都,垫江,武隆,忠县,开县,云阳,奉节,巫山,巫溪,石柱,秀山,酉阳,彭水,江津,合川,永川,南川"
x( 4 )="石家庄,邯郸,邢台,保定,张家口,承德,廊坊,唐山,秦皇岛,沧州,衡水"
x( 5 )="太原,大同,阳泉,长治,晋城,朔州,吕梁,忻州,晋中,临汾,运城"
x( 6 )="呼和浩特,包头,乌海,赤峰,呼伦贝尔盟,阿拉善盟,哲里木盟,兴安盟,乌兰察布盟,锡林郭勒盟,巴彦淖尔盟,伊克昭盟"
x( 7 )="沈阳,大连,鞍山,抚顺,本溪,丹东,锦州,营口,阜新,辽阳,盘锦,铁岭,朝阳,葫芦岛"
x( 8 )="长春,吉林,四平,辽源,通化,白山,松原,白城,延边"
x( 9 )="哈尔滨,齐齐哈尔,牡丹江,佳木斯,大庆,绥化,鹤岗,鸡西,黑河,双鸭山,伊春,七台河,大兴安岭"
x( 10 )="南京,镇江,苏州,南通,扬州,盐城,徐州,连云港,常州,无锡,宿迁,泰州,淮安"
x( 11 )="杭州,宁波,温州,嘉兴,湖州,绍兴,金华,衢州,舟山,台州,丽水"
x( 12 )="合肥,芜湖,蚌端口,马鞍山,淮北,铜陵,安庆,黄山,滁州,宿州,池州,淮南,巢湖,阜阳,六安,宣城,亳州"
x( 13 )="福州,厦门,莆田,三明,泉州,漳州,南平,龙岩,宁德，东山"
x( 14 )="南昌市,景德镇,九江,鹰潭,萍乡,新馀,赣州,吉安,宜春,抚州,上饶"
x( 15 )="济南,青岛,淄博,枣庄,东营,烟台,潍坊,济宁,泰安,威海,日照,莱芜,临沂,德州,聊城,滨州,菏泽"
x( 16 )="郑州,开封,洛阳,平顶山,安阳,鹤壁,新乡,焦作,濮阳,许昌,漯河,三门峡,南阳,商丘,信阳,周口,驻马店,济源"
x( 17 )="武汉,宜昌,荆州,襄樊,黄石,荆门,黄冈,十堰,恩施,潜江,天门,仙桃,随州,咸宁,孝感,鄂州"
x( 18 )="长沙,常德,株洲,湘潭,衡阳,岳阳,邵阳,益阳,娄底,怀化,郴州,永州,湘西,张家界"
x( 19 )="广州,深圳,珠海,汕头,东莞,中山,佛山,韶关,江门,湛江,茂名,肇庆,惠州,梅州,汕尾,河源,阳江,清远,潮州,揭阳,云浮"
x( 20 )="南宁,柳州,桂林,梧州,北海,防城港,钦州,贵港,玉林,南宁地区,柳州地区,贺州,百色,河池"
x( 21 )="海口,三亚"
x( 22 )="成都,绵阳,德阳,自贡,攀枝花,广元,内江,乐山,南充,宜宾,广安,达川,雅安,眉山,甘孜,凉山,泸州"
x( 23 )="贵阳,六盘水,遵义,安顺,铜仁,黔西南,毕节,黔东南,黔南"
x( 24 )="昆明,大理,曲靖,玉溪,昭通,楚雄,红河,文山,思茅,西双版纳,保山,德宏,丽江,怒江,迪庆,临沧"
x( 25 )="拉萨,日喀则,山南,林芝,昌都,阿里,那曲"
x( 26 )="西安,宝鸡,咸阳,铜川,渭南,延安,榆林,汉中,安康,商洛"
x( 27 )="兰州,嘉峪关,金昌,白银,天水,酒泉,张掖,武威,定西,陇南,平凉,庆阳,临夏,甘南"
x( 28 )="银川,石嘴山,吴忠,固原"
x( 29 )="西宁,海东,海南,海北,黄南,玉树,果洛,海西"
x( 30 )="乌鲁木齐,石河子,克拉玛依,伊犁,巴音郭勒,昌吉,克孜勒苏柯尔克孜,博 尔塔拉,吐鲁番,哈密,喀什,和田,阿克苏"
x( 31 )=""
x( 32 )=""
x( 33 )="台北,高雄,台中,台南,屏东,南投,云林,新竹,彰化,苗栗,嘉义,花莲,桃园,宜兰,基隆,台东,金门,马祖,澎湖"

function test(a,b)
dim num,x1,i
num =a.selectedIndex
x1=split(x(num),",")
b.options.length=ubound(x1)+1
For i = 0 to ubound(x1)
b.options(i).text =x1(i)
b.options(i).value = x1(i)
next
end function
-->
</script>
<body>
<select name="a" onChange="vbscript:test a,b">
<option value= 0 >北京</option>
<option value= 1 >上海</option>
<option value= 2 >天津</option>
<option value= 3 >重庆</option>
<option value= 4 >河北</option>
<option value= 5 >山西</option>
<option value= 6 >内蒙古</option>
<option value= 7 >辽宁</option>
<option value= 8 >吉林</option>
<option value= 9 >黑龙江</option>
<option value= 10 >江苏</option>
<option value= 11 >浙江</option>
<option value= 12 >安徽</option>
<option value= 13 >福建</option>
<option value= 14 >江西</option>
<option value= 15 >山东</option>
<option value= 16 >河南</option>
<option value= 17 >湖北</option>
<option value= 18 >湖南</option>
<option value= 19 >广东</option>
<option value= 20 >广西</option>
<option value= 21 >海南</option>
<option value= 22 >四川</option>
<option value= 23 >贵州</option>
<option value= 24 >云南</option>
<option value= 25 >西藏</option>
<option value= 26 >陕西</option>
<option value= 27 >甘肃</option>
<option value= 28 >宁夏</option>
<option value= 29 >青海</option>
<option value= 30 >新疆</option>
<option value= 31 >香港</option>
<option value= 32 >澳门</option>
<option value= 33 >台湾</option>

</select>
<select name="b">
</select>
</body>

Ⅵ 呼和浩特电脑学校，哪里能学SQL数据库

可以介绍一个，第五维教育，费用不贵，因为采用小班授课，教学质量是完全得到保证的！

Ⅶ 呼和浩特哪里有C语言的培训学校啊

大正计算机培训中心 坐落在内蒙古工业大学校区 作为计算机等级考试试点的内工大指定的培训机构 能够以最短的时间帮助你通过计算机等级考试 不参加他的培训 只购买相关教材也会受益非浅的 我是内工大学生 深有感触啊
地址：爱民路51号 内工大 院内

Ⅷ 本人工作中用到oracle数据库，有sql基础,不知道呼和浩特有没有ocp的培训机构另外呼市有考ocp的地方吗

很多培训机构都有oracle培训的，ocp考试培训机构会给你安排，ocp考试不像oca，不会挑地方。

Ⅸ 全国省市数据库(不包括县)

要名称还是区号，还是什么，说明白，怎么给你？

0513 南通
0514 杨州
0515 盐城
0516 徐州
0517 淮阴
0518 连云港
0519 常州
0520 常熟
0523 泰州
0527 沭阳
0530 荷泽
0531 济南
0532 青岛
0533 淄博
0534 德州
0535 烟台
0536 潍坊
0537 济宁
0538 泰安
0539 临沂
0543 滨州
0546 东营
0550 滁州
0551 合肥
0552 蚌端口
0553 芜湖
0554 淮南
0555 马鞍山
0556 安庆
0557 宿州
0558 阜阳
0559 黄山市
0561 淮北
0562 铜陵
0563 宣州
0564 六安
0565 巢湖
0566 贵池
0570 衢州
0571 杭州
0572 湖州
0573 嘉兴
0574 宁波
0575 绍兴
0576 临海
0577 温州
0578 丽水
0579 金华
0580 舟山
0591 福州
0592 厦门
0593 宁德
0594 莆田
0595 泉州
0596 漳州
0597 龙岩
0598 三明
0599 南平
0631 威海
0632 枣庄
0633 日照
0634 莱芜
0635 聊城
0660 汕尾
0661 潮阳
0662 阳江
0663 揭阳
0668 茂名
0691 景洪
0692 瑞丽
0701 鹰潭
0710 襄樊
0711 鄂州
0712 孝感
0713 黄州市
0714 黄石
0715 咸宁
0716 江陵
0717 宜昌
0718 建始
0719 十堰
0722 随州
0724 荆门
0955 中卫
010 北京
023 重庆
028 成都
0313 张家口
0317 沧州
0349 朔州
0354 榆次
0358 离石
0879 思茅
0888 丽江
0895 昌都
0728 洪湖
0903 和田
0910 咸阳
0915 安康
0930 临夏
0934 西峰
0939 陇南
0359 运城
0370 商丘
0371 郑州
0372 安阳
0373 新乡
0374 许昌
0375 平顶山
0376 信阳
0377 南阳
0378 开封
0379 洛阳
0391 焦作市
0392 鹤壁
0393 台前
0394 周口
0395 漯河
0396 驻马店
0397 息县
0398 三门峡
0410 铁岭
0411 大连
0412 鞍山
0413 抚顺
0414 本溪
0415 丹东
0416 锦州
0417 营口
0418 阜新
0419 辽阳
0421 朝阳
0427 盘锦
0429 葫芦岛
0431 长春
0432 吉林
0433 延吉
0434 四平
0435 通化
0436 白城
0437 辽源
0438 松原
0439 白山
0440 珲春
0448 梅河口
0451 哈尔滨
0452 齐齐哈尔
0453 牡丹江
0454 佳木斯
0455 绥化
0456 黑河
0457 加格达奇
0458 伊春
0459 大庆
0464 七台河
0467 鸡西
0468 鹤岗
0469 双鸦山
0470 海拉尔
0471 呼和浩特
0472 包头
0473 乌海市
0474 集宁
0475 通辽
0476 赤峰
0477 东胜
0478 巴彦淖尔盟
0479 锡林浩特
0482 乌兰浩特
0483 阿 盟
0510 无锡
0511 镇江
0512 苏州
020 广州
021 上海
022 天津
024 沈阳
025 南京
027 武汉
029 西安
0310 邯郸
0311 石家庄
0312 保定
0314 承德
0315 唐山
0316 廊坊
0318 衡水
0319 邢台
0335 秦皇岛
0350 忻州
0351 太原
0352 大同
0353 阳泉
0355 长治
0356 晋城
0357 临汾
0818 达川
0825 遂宁
0826 华蓥
0827 巴中
0830 泸州
0831 宜宾
0832 内江
0833 乐山
0834 西昌
0835 雅安
0836 康定
0837 马尔康
0838 德阳
0839 广元
0851 贵阳
0852 遵义
0853 安顺
0854 都匀
0855 凯里
0856 铜仁
0857 毕节
0858 六盘水
0859 兴义
0870 昭通
0871 昆明
0872 大理
0873 个旧
0874 曲靖
0875 保山
0876 文山
0877 玉溪
0878 楚雄
0883 镇康
0886 福贡
0887 中甸
0891 拉萨
0892 日喀则
0893 山南
0894 林芝
0896 那曲
0897 阿里
0898 海口
0899 三亚
0901 裕民
0902 哈密
0906 富蕴
0908 阿图什
0909 博乐
0911 延安
0912 榆林
0913 渭南
0914 商州
0916 汉中
0917 宝鸡
0919 铜川
0931 兰州
0932 定西
0933 平凉
0935 武威
0936 张掖
0937 酒泉
0938 天水
0943 白银
0951 银川
0952 石嘴山
0953 吴忠
0954 固原
0970 海晏
0971 西宁
0972 海东
0973 同仁
0974 共和
0975 玛沁
0976 玉树
0977 海西
0979 格尔木
0990 克拉玛依
0991 乌鲁木齐
0992 奎屯
0993 石河子
0994 昌吉
0995 吐鲁番
0996 库尔勒
0997 阿克苏
0998 喀什
0999 伊宁
0941 甘南州
0730 岳阳
0731 长沙
0732 湘潭
0733 株州
0734 衡阳
0735 郴州
0736 常德
0737 益阳
0738 娄底
0739 邵阳
0743 吉首
0744 张家界
0745 怀化
0746 冷水滩
0750 江门
0751 韶关
0752 惠州
0753 梅州
0754 汕头
0755 深圳
0756 珠海
0757 佛山
0758 肇庆
0759 湛江
0760 中山
0762 河源
0763 清远
0765 顺德
0766 云浮
0768 潮州
0769 东莞
0770 防城港
0771 南宁
0772 柳州
0773 桂林
0774 梧州
0775 玉林
0776 百色
0777 钦州
0778 河池
0779 北海
0790 新余
0791 南昌
0792 九江
0793 上饶
0794 临州
0795 宜春
0796 吉安
0797 赣州
0798 景德镇
0799 萍乡
0812 攀枝花
0813 自贡
0816 绵阳
0817 南充

Ⅹ Microsoft OLE DB Provider for SQL Server (0x80040E14)

<%
set rs=server.createobject("adodb.recordset")
Name=request("name")
set rs=server.createobject("adodb.recordset")
sqltext="select * from dongtaixinxi where [name]='" & Name &"'"'字符串要加引号
rs.open sqltext,conn,1,1
%>