c# sql省市联动
时间：2021-07-01 10:21:17
帮助过：3人阅读
[Book]
GO
INSERT INTO Area(city, parentid)
VALUES (
‘北京市‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘天津市‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘上海市‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘重庆市‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘河北省‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘山西省‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘台湾省‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘辽宁省‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘吉林省‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘黑龙江省‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘江苏省‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘浙江省‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘安徽省‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘福建省‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘江西省‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘山东省‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘河南省‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘湖北省‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘湖南省‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘广东省‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘甘肃省‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘四川省‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘贵州省‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘海南省‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘云南省‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘青海省‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘陕西省‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘广西壮族自治区‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘西藏自治区‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘宁夏回族自治区‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘新疆维吾尔自治区‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘内蒙古自治区‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘澳门特别行政区‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘香港特别行政区‘,
0);
INSERT INTO Area(city, parentid)
VALUES (
‘北京市‘,
1);
INSERT INTO Area(city, parentid)
VALUES (
‘天津市‘,
2);
INSERT INTO Area(city, parentid)
VALUES (
‘上海市‘,
3);
INSERT INTO Area(city, parentid)
VALUES (
‘重庆市‘,
4);
INSERT INTO Area(city, parentid)
VALUES (
‘石家庄市‘,
5);
INSERT INTO Area(city, parentid)
VALUES (
‘保定市‘,
5);
INSERT INTO Area(city, parentid)
VALUES (
‘唐山市‘,
5);
INSERT INTO Area(city, parentid)
VALUES (
‘廊坊市‘,
5);
INSERT INTO Area(city, parentid)
VALUES (
‘张家口市‘,
5);
INSERT INTO Area(city, parentid)
VALUES (
‘承德市‘,
5);
INSERT INTO Area(city, parentid)
VALUES (
‘沧州市‘,
5);
INSERT INTO Area(city, parentid)
VALUES (
‘秦皇岛市‘,
5);
INSERT INTO Area(city, parentid)
VALUES (
‘衡水市‘,
5);
INSERT INTO Area(city, parentid)
VALUES (
‘邢台市‘,
5);
INSERT INTO Area(city, parentid)
VALUES (
‘邯郸市‘,
5);
INSERT INTO Area(city, parentid)
VALUES (
‘太原市‘,
6);
INSERT INTO Area(city, parentid)
VALUES (
‘临汾市‘,
6);
INSERT INTO Area(city, parentid)
VALUES (
‘吕梁市‘,
6);
INSERT INTO Area(city, parentid)
VALUES (
‘大同市‘,
6);
INSERT INTO Area(city, parentid)
VALUES (
‘忻州市‘,
6);
INSERT INTO Area(city, parentid)
VALUES (
‘晋中市‘,
6);
INSERT INTO Area(city, parentid)
VALUES (
‘晋城市‘,
6);
INSERT INTO Area(city, parentid)
VALUES (
‘朔州市‘,
6);
INSERT INTO Area(city, parentid)
VALUES (
‘运城市‘,
6);
INSERT INTO Area(city, parentid)
VALUES (
‘长治市‘,
6);
INSERT INTO Area(city, parentid)
VALUES (
‘阳泉市‘,
6);
INSERT INTO Area(city, parentid)
VALUES (
‘台北市‘,
7);
INSERT INTO Area(city, parentid)
VALUES (
‘云林县‘,
7);
INSERT INTO Area(city, parentid)
VALUES (
‘南投县‘,
7);
INSERT INTO Area(city, parentid)
VALUES (
‘台东县‘,
7);
INSERT INTO Area(city, parentid)
VALUES (
‘台中县‘,
7);
INSERT INTO Area(city, parentid)
VALUES (
‘台中市‘,
7);
INSERT INTO Area(city, parentid)
VALUES (
‘台北县‘,
7);
INSERT INTO Area(city, parentid)
VALUES (
‘台南县‘,
7);
INSERT INTO Area(city, parentid)
VALUES (
‘台南市‘,
7);
INSERT INTO Area(city, parentid)
VALUES (
‘嘉义县‘,
7);
INSERT INTO Area(city, parentid)
VALUES (
‘嘉义市‘,
7);
INSERT INTO Area(city, parentid)
VALUES (
‘基隆市‘,
7);
INSERT INTO Area(city, parentid)
VALUES (
‘宜兰县‘,
7);
INSERT INTO Area(city, parentid)
VALUES (
‘屏东县‘,
7);
INSERT INTO Area(city, parentid)
VALUES (
‘彰化县‘,
7);
INSERT INTO Area(city, parentid)
VALUES (
‘新竹县‘,
7);
INSERT INTO Area(city, parentid)
VALUES (
‘新竹市‘,
7);
INSERT INTO Area(city, parentid)
VALUES (
‘桃园县‘,
7);
INSERT INTO Area(city, parentid)
VALUES (
‘澎湖县‘,
7);
INSERT INTO Area(city, parentid)
VALUES (
‘花莲县‘,
7);
INSERT INTO Area(city, parentid)
VALUES (
‘苗栗县‘,
7);
INSERT INTO Area(city, parentid)
VALUES (
‘高雄县‘,
7);
INSERT INTO Area(city, parentid)
VALUES (
‘高雄市‘,
7);
INSERT INTO Area(city, parentid)
VALUES (
‘沈阳市‘,
8);
INSERT INTO Area(city, parentid)
VALUES (
‘大连市‘,
8);
INSERT INTO Area(city, parentid)
VALUES (
‘丹东市‘,
8);
INSERT INTO Area(city, parentid)
VALUES (
‘抚顺市‘,
8);
INSERT INTO Area(city, parentid)
VALUES (
‘朝阳市‘,
8);
INSERT INTO Area(city, parentid)
VALUES (
‘本溪市‘,
8);
INSERT INTO Area(city, parentid)
VALUES (
‘盘锦市‘,
8);
INSERT INTO Area(city, parentid)
VALUES (
‘营口市‘,
8);
INSERT INTO Area(city, parentid)
VALUES (
‘葫芦岛市‘,
8);
INSERT INTO Area(city, parentid)
VALUES (
‘辽阳市‘,
8);
INSERT INTO Area(city, parentid)
VALUES (
‘铁岭市‘,
8);
INSERT INTO Area(city, parentid)
VALUES (
‘锦州市‘,
8);
INSERT INTO Area(city, parentid)
VALUES (
‘阜新市‘,
8);
INSERT INTO Area(city, parentid)
VALUES (
‘鞍山市‘,
8);
INSERT INTO Area(city, parentid)
VALUES (
‘长春市‘,
9);
INSERT INTO Area(city, parentid)
VALUES (
‘吉林市‘,
9);
INSERT INTO Area(city, parentid)
VALUES (
‘四平市‘,
9);
INSERT INTO Area(city, parentid)
VALUES (
‘延边朝鲜族自治州‘,
9);
INSERT INTO Area(city, parentid)
VALUES (
‘松原市‘,
9);
INSERT INTO Area(city, parentid)
VALUES (
‘白城市‘,
9);
INSERT INTO Area(city, parentid)
VALUES (
‘白山市‘,
9);
INSERT INTO Area(city, parentid)
VALUES (
‘辽源市‘,
9);
INSERT INTO Area(city, parentid)
VALUES (
‘通化市‘,
9);
INSERT INTO Area(city, parentid)
VALUES (
‘哈尔滨市‘,
10);
INSERT INTO Area(city, parentid)
VALUES (
‘七台河市‘,
10);
INSERT INTO Area(city, parentid)
VALUES (
‘伊 春 市‘,
10);
INSERT INTO Area(city, parentid)
VALUES (
‘佳木斯市‘,
10);
INSERT INTO Area(city, parentid)
VALUES (
‘双鸭山市‘,
10);
INSERT INTO Area(city, parentid)
VALUES (
‘大 庆 市‘,
10);
INSERT INTO Area(city, parentid)
VALUES (
‘大兴安岭地区‘,
10);
INSERT INTO Area(city, parentid)
VALUES (
‘牡丹江市‘,
10);
INSERT INTO Area(city, parentid)
VALUES (
‘绥 化 市‘,
10);
INSERT INTO Area(city, parentid)
VALUES (
‘鸡 西 市‘,
10);
INSERT INTO Area(city, parentid)
VALUES (
‘鹤 岗 市‘,
10);
INSERT INTO Area(city, parentid)
VALUES (
‘黑 河 市‘,
10);
INSERT INTO Area(city, parentid)
VALUES (
‘齐齐哈尔市‘,
10);
INSERT INTO Area(city, parentid)
VALUES (
‘南京市‘,
11);
INSERT INTO Area(city, parentid)
VALUES (
‘南通市‘,
11);
INSERT INTO Area(city, parentid)
VALUES (
‘宿迁市‘,
11);
INSERT INTO Area(city, parentid)
VALUES (
‘常州市‘,
11);
INSERT INTO Area(city, parentid)
VALUES (
‘徐州市‘,
11);
INSERT INTO Area(city, parentid)
VALUES (
‘扬州市‘,
11);
INSERT INTO Area(city, parentid)
VALUES (
‘无锡市‘,
11);
INSERT INTO Area(city, parentid)
VALUES (
‘泰州市‘,
11);
INSERT INTO Area(city, parentid)
VALUES (
‘淮安市‘,
11);
INSERT INTO Area(city, parentid)
VALUES (
‘盐城市‘,
11);
INSERT INTO Area(city, parentid)
VALUES (
‘苏州市‘,
11);
INSERT INTO Area(city, parentid)
VALUES (
‘连云港市‘,
11);
INSERT INTO Area(city, parentid)
VALUES (
‘镇江市‘,
11);
INSERT INTO Area(city, parentid)
VALUES (
‘杭州市‘,
12);
INSERT INTO Area(city, parentid)
VALUES (
‘丽水市‘,
12);
INSERT INTO Area(city, parentid)
VALUES (
‘台州市‘,
12);
INSERT INTO Area(city, parentid)
VALUES (
‘嘉兴市‘,
12);
INSERT INTO Area(city, parentid)
VALUES (
‘宁波市‘,
12);
INSERT INTO Area(city, parentid)
VALUES (
‘温州市‘,
12);
INSERT INTO Area(city, parentid)
VALUES (
‘湖州市‘,
12);
INSERT INTO Area(city, parentid)
VALUES (
‘绍兴市‘,
12);
INSERT INTO Area(city, parentid)
VALUES (
‘舟山市‘,
12);
INSERT INTO Area(city, parentid)
VALUES (
‘衢州市‘,
12);
INSERT INTO Area(city, parentid)
VALUES (
‘金华市‘,
12);
INSERT INTO Area(city, parentid)
VALUES (
‘合肥市‘,
13);
INSERT INTO Area(city, parentid)
VALUES (
‘亳州市‘,
13);
INSERT INTO Area(city, parentid)
VALUES (
‘六安市‘,
13);
INSERT INTO Area(city, parentid)
VALUES (
‘安庆市‘,
13);
INSERT INTO Area(city, parentid)
VALUES (
‘宣城市‘,
13);
INSERT INTO Area(city, parentid)
VALUES (
‘宿州市‘,
13);
INSERT INTO Area(city, parentid)
VALUES (
‘巢湖市‘,
13);
INSERT INTO Area(city, parentid)
VALUES (
‘池州市‘,
13);
INSERT INTO Area(city, parentid)
VALUES (
‘淮北市‘,
13);
INSERT INTO Area(city, parentid)
VALUES (
‘淮南市‘,
13);
INSERT INTO Area(city, parentid)
VALUES (
‘滁州市‘,
13);
INSERT INTO Area(city, parentid)
VALUES (
‘芜湖市‘,
13);
INSERT INTO Area(city, parentid)
VALUES (
‘蚌埠市‘,
13);
INSERT INTO Area(city, parentid)
VALUES (
‘铜陵市‘,
13);
INSERT INTO Area(city, parentid)
VALUES (
‘阜阳市‘,
13);
INSERT INTO Area(city, parentid)
VALUES (
‘马鞍山市‘,
13);
INSERT INTO Area(city, parentid)
VALUES (
‘黄山市‘,
13);
INSERT INTO Area(city, parentid)
VALUES (
‘福州市‘,
14);
INSERT INTO Area(city, parentid)
VALUES (
‘三明市‘,
14);
INSERT INTO Area(city, parentid)
VALUES (
‘南平市‘,
14);
INSERT INTO Area(city, parentid)
VALUES (
‘厦门市‘,
14);
INSERT INTO Area(city, parentid)
VALUES (
‘宁德市‘,
14);
INSERT INTO Area(city, parentid)
VALUES (
‘泉州市‘,
14);
INSERT INTO Area(city, parentid)
VALUES (
‘漳州市‘,
14);
INSERT INTO Area(city, parentid)
VALUES (
‘莆田市‘,
14);
INSERT INTO Area(city, parentid)
VALUES (
‘龙岩市‘,
14);
INSERT INTO Area(city, parentid)
VALUES (
‘南昌市‘,
15);
INSERT INTO Area(city, parentid)
VALUES (
‘上饶市‘,
15);
INSERT INTO Area(city, parentid)
VALUES (
‘九江市‘,
15);
INSERT INTO Area(city, parentid)
VALUES (
‘吉安市‘,
15);
INSERT INTO
