呼和浩特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
%>