⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 tb_area.sql

📁 《全国政区数据表》 SQL文档
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140108', '尖草坪区', '1401', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140109', '万柏林区', '1401', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140110', '晋源区', '1401', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140121', '清徐县', '1401', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140122', '阳曲县', '1401', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140123', '娄烦县', '1401', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140181', '古交市', '1401', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1402', '大同', '14', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140201', '市辖区', '1402', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140202', '城  区', '1402', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140203', '矿  区', '1402', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140211', '南郊区', '1402', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140212', '新荣区', '1402', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140221', '阳高县', '1402', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140222', '天镇县', '1402', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140223', '广灵县', '1402', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140224', '灵丘县', '1402', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140225', '浑源县', '1402', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140226', '左云县', '1402', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140227', '大同县', '1402', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1403', '阳泉', '14', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140301', '市辖区', '1403', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140302', '城  区', '1403', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140303', '矿  区', '1403', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140311', '郊  区', '1403', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140321', '平定县', '1403', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140322', '盂  县', '1403', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1404', '长治', '14', 1, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140401', '市辖区', '1404', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140402', '城  区', '1404', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140411', '郊  区', '1404', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140421', '长治县', '1404', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140423', '襄垣县', '1404', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140424', '屯留县', '1404', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140425', '平顺县', '1404', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140426', '黎城县', '1404', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140427', '壶关县', '1404', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140428', '长子县', '1404', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140429', '武乡县', '1404', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140430', '沁  县', '1404', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140431', '沁源县', '1404', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140481', '潞城市', '1404', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1405', '晋城', '14', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140501', '市辖区', '1405', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140502', '城  区', '1405', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140521', '沁水县', '1405', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140522', '阳城县', '1405', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140524', '陵川县', '1405', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140525', '泽州县', '1405', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140581', '高平市', '1405', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1406', '朔州', '14', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140601', '市辖区', '1406', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140602', '朔城区', '1406', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140603', '平鲁区', '1406', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140621', '山阴县', '1406', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140622', '应  县', '1406', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140623', '右玉县', '1406', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140624', '怀仁县', '1406', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1407', '晋中', '14', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140701', '市辖区', '1407', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140702', '榆次区', '1407', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140721', '榆社县', '1407', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140722', '左权县', '1407', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140723', '和顺县', '1407', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140724', '昔阳县', '1407', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140725', '寿阳县', '1407', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140726', '太谷县', '1407', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140727', '祁  县', '1407', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140728', '平遥县', '1407', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140729', '灵石县', '1407', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140781', '介休市', '1407', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1408', '运城', '14', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140801', '市辖区', '1408', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140802', '盐湖区', '1408', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140821', '临猗县', '1408', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140822', '万荣县', '1408', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140823', '闻喜县', '1408', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140824', '稷山县', '1408', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140825', '新绛县', '1408', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140826', '绛  县', '1408', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140827', '垣曲县', '1408', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140828', '夏  县', '1408', 0, 2, NULL)
GO
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -