《全国行政区表包括(地区市县)SQL.doc》由会员分享，可在线阅读，更多相关《全国行政区表包括(地区市县)SQL.doc（84页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、,CREATE TABLE dbo.AreaCode_T (AreaCode_Code int NOT NULL ,AreaCode_Name varchar (32) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON PRIMARYGOinsert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (110000,北京市);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (110101,东城区);insert into AreaCode_T
2、(AreaCode_Code,AreaCode_Name) values (110102,西城区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (110103,崇文区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (110104,宣武区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (110105,朝阳区);insert into AreaCode_T(AreaCode_Co
3、de,AreaCode_Name) values (110106,丰台区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (110107,石景山区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (110108,海淀区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (110109,门头沟区);insert into AreaCode_T(AreaCode_Code,AreaCod
4、e_Name) values (110111,房山区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (110112,通州区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (110113,顺义区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (110114,昌平区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) valu
5、es (110115,大兴区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (110116,怀柔区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (110117,平谷区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (110228,密云县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (110229,延
6、庆县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (120000,天津市);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (120101,和平区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (120102,河东区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (120103,河西区);insert i
7、nto AreaCode_T(AreaCode_Code,AreaCode_Name) values (120104,南开区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (120105,河北区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (120106,红桥区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (120107,塘沽区);insert into AreaCode
8、_T(AreaCode_Code,AreaCode_Name) values (120108,汉沽区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (120109,大港区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (120110,东丽区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (120111,西青区);insert into AreaCode_T(AreaCode_
9、Code,AreaCode_Name) values (120112,津南区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (120113,北辰区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (120114,武清区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (120115,宝坻区);insert into AreaCode_T(AreaCode_Code,AreaCod
10、e_Name) values (120221,宁河县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (120223,静海县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (120225,蓟县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130000,河北省);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) value
11、s (130100,石家庄市);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130102,长安区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130103,桥东区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130104,桥西区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130105,新
12、华区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130107,井陉矿区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130108,裕华区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130121,井陉县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130123,正定县);insert
13、into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130124,栾城县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130125,行唐县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130126,灵寿县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130127,高邑县);insert into AreaCod
14、e_T(AreaCode_Code,AreaCode_Name) values (130128,深泽县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130129,赞皇县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130130,无极县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130131,平山县);insert into AreaCode_T(AreaCode
15、_Code,AreaCode_Name) values (130132,元氏县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130133,赵县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130181,辛集市);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130182,藁城市);insert into AreaCode_T(AreaCode_Code,AreaCod
16、e_Name) values (130183,晋州市);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130184,新乐市);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130185,鹿泉市);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130200,唐山市);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) valu
17、es (130202,路南区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130203,路北区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130204,古冶区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130205,开平区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130207,丰
18、南区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130208,丰润区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130223,滦县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130224,滦南县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130225,乐亭县);insert in
19、to AreaCode_T(AreaCode_Code,AreaCode_Name) values (130227,迁西县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130229,玉田县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130230,唐海县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130281,遵化市);insert into AreaCode_
20、T(AreaCode_Code,AreaCode_Name) values (130283,迁安市);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130300,秦皇岛市);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130302,海港区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130303,山海关区);insert into AreaCode_T(AreaCode
21、_Code,AreaCode_Name) values (130304,北戴河区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130321,青龙满族自治县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130322,昌黎县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130323,抚宁县);insert into AreaCode_T(AreaCode_Code,A
22、reaCode_Name) values (130324,卢龙县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130400,邯郸市);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130402,邯山区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130403,丛台区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name
23、) values (130404,复兴区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130406,峰峰矿区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130421,邯郸县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130423,临漳县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (1
24、30424,成安县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130425,大名县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130426,涉县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130427,磁县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130428,肥乡县);ins
25、ert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130429,永年县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130430,邱县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130431,鸡泽县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130432,广平县);insert into Area
26、Code_T(AreaCode_Code,AreaCode_Name) values (130433,馆陶县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130434,魏县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130435,曲周县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130481,武安市);insert into AreaCode_T(AreaCo
27、de_Code,AreaCode_Name) values (130500,邢台市);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130502,桥东区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130503,桥西区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130521,邢台县);insert into AreaCode_T(AreaCode_Code,Area
28、Code_Name) values (130522,临城县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130523,内丘县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130524,柏乡县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130525,隆尧县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) v
29、alues (130526,任县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130527,南和县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130528,宁晋县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130529,巨鹿县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130530
30、,新河县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130531,广宗县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130532,平乡县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130533,威县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130534,清河县);insert
31、into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130535,临西县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130581,南宫市);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130582,沙河市);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130600,保定市);insert into AreaCod
32、e_T(AreaCode_Code,AreaCode_Name) values (130602,新市区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130603,北市区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130604,南市区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130621,满城县);insert into AreaCode_T(AreaCode
33、_Code,AreaCode_Name) values (130622,清苑县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130623,涞水县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130624,阜平县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130625,徐水县);insert into AreaCode_T(AreaCode_Code,AreaCo
34、de_Name) values (130626,定兴县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130627,唐县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130628,高阳县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130629,容城县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) valu
35、es (130630,涞源县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130631,望都县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130632,安新县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130633,易县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130634,曲阳
36、县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130635,蠡县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130636,顺平县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130637,博野县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130638,雄县);insert into
37、 AreaCode_T(AreaCode_Code,AreaCode_Name) values (130681,涿州市);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130682,定州市);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130683,安国市);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130684,高碑店市);insert into AreaCode_T
38、(AreaCode_Code,AreaCode_Name) values (130700,张家口市);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130702,桥东区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130703,桥西区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130705,宣化区);insert into AreaCode_T(AreaCode_C
39、ode,AreaCode_Name) values (130706,下花园区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130721,宣化县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130722,张北县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130723,康保县);insert into AreaCode_T(AreaCode_Code,AreaCod
40、e_Name) values (130724,沽源县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130725,尚义县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130726,蔚县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130727,阳原县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) value
41、s (130728,怀安县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130729,万全县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130730,怀来县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130731,涿鹿县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130732,赤城
42、县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130733,崇礼县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130800,承德市);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130802,双桥区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130803,双滦区);insert in
43、to AreaCode_T(AreaCode_Code,AreaCode_Name) values (130804,鹰手营子矿区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130821,承德县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130822,兴隆县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130823,平泉县);insert into AreaCo
44、de_T(AreaCode_Code,AreaCode_Name) values (130824,滦平县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130825,隆化县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130826,丰宁满族自治县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130827,宽城满族自治县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130828,围场满族蒙古族自治县);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130900,沧州市);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130902,新华区);insert into AreaCode_T(AreaCode_Code,AreaCode_Name) values (130903,运河区);insert into Ar