📄 tb_area.sql

📁 《全国政区数据表》 SQL文档
💻 SQL
📖 第 1 页 / 共 5 页
字号:
12 3 4 5 下一页
CREATE TABLE [dbo].[TB_Area] (
  [AreaCode] varchar(20) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [AreaName] nvarchar(20) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [ParentAreaCode] varchar(20) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [Root] bit NOT NULL,
  [Zone] smallint NOT NULL,
  [NavigateURL] varchar(100) COLLATE Chinese_PRC_CI_AS,
  CONSTRAINT [PK_TB_Area] PRIMARY KEY CLUSTERED ([AreaCode])
)
ON [PRIMARY]
GO

/* Data for the `TB_Area` table  (Records 1 - 500) */
INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('0001', '中国', '0000', 1, 0, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('11', '北京', '0001', 1, 2, 'MartNavigate\BeiJing.aspx?AreaCode=11')
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1101', '北京市辖', '11', 1, 2, NULL)
GO

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

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

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('110103', '崇文区', '1101', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('110104', '宣武区', '1101', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('110105', '朝阳区', '1101', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('110106', '丰台区', '1101', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('110107', '石景山区', '1101', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('110108', '海淀区', '1101', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('110109', '门头沟区', '1101', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('110111', '房山区', '1101', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('110112', '通州区', '1101', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('110113', '顺义区', '1101', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('110114', '昌平区', '1101', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1102', '北京县辖', '11', 1, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('110224', '大兴县', '1102', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('110226', '平谷县', '1102', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('110227', '怀柔县', '1102', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('110228', '密云县', '1102', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('110229', '延庆县', '1102', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('12', '天津', '0001', 1, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1201', '天津市辖', '12', 1, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('120101', '和平区', '1201', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('120102', '河东区', '1201', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('120103', '河西区', '1201', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('120104', '南开区', '1201', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('120105', '河北区', '1201', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('120106', '红桥区', '1201', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('120107', '塘沽区', '1201', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('120108', '汉沽区', '1201', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('120109', '大港区', '1201', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('120110', '东丽区', '1201', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('120111', '西青区', '1201', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('120112', '津南区', '1201', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('120113', '北辰区', '1201', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('120114', '武清区', '1201', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1202', '天津县辖', '12', 1, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('120221', '宁河县', '1202', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('120223', '静海县', '1202', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('120224', '宝坻县', '1202', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('120225', '蓟  县', '1202', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('13', '河北', '0001', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1301', '石家庄', '13', 1, 2, NULL)
GO

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

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130102', '长安区', '1301', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130103', '桥东区', '1301', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130104', '桥西区', '1301', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130105', '新华区', '1301', 0, 2, NULL)
GO

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

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130107', '井陉矿区', '1301', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130121', '井陉县', '1301', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130123', '正定县', '1301', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130124', '栾城县', '1301', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130125', '行唐县', '1301', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130126', '灵寿县', '1301', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130127', '高邑县', '1301', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130128', '深泽县', '1301', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130129', '赞皇县', '1301', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130130', '无极县', '1301', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130131', '平山县', '1301', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130132', '元氏县', '1301', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130133', '赵  县', '1301', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130181', '辛集市', '1301', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130182', '藁城市', '1301', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130183', '晋州市', '1301', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130184', '新乐市', '1301', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130185', '鹿泉市', '1301', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1302', '唐山', '13', 0, 2, NULL)
GO

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

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130202', '路南区', '1302', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130203', '路北区', '1302', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130204', '古冶区', '1302', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130205', '开平区', '1302', 0, 2, NULL)
GO

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

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130221', '丰润县', '1302', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130223', '滦  县', '1302', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130224', '滦南县', '1302', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130225', '乐亭县', '1302', 0, 2, NULL)
GO
12 3 4 5 下一页
💿 文件大小 25 K
👤 上传用户 wangcong200500
📂 所属分类软件设计/软件工程
🏷️ 相关标签

#SQL #数据表 #文档
⌨️ 快捷键说明

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