四级中国各省市区代码名称Sql脚本

中国各省市区代码名称(四级)，共有45730条数据。已有上下级父子关系，可以直接导入数据库使用。 部分代码如下： CREATE TABLE [dbo].[tb_City]( [RecNo] [int] NOT NULL, [Code] [varchar](50) NULL, [Name] [nvarchar](50) NULL, [ParentNo] [int] NULL, CONSTRAINT [PK_tb_City] PRIMARY KEY CLUSTERED ( [RecNo] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (1, N'110000', N'北京市', 0) INSERT [dbo].[tb_City] ( [RecNo], [Code], [Name], [ParentNo]) VALUES (2, N'110101', N'东城区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (3, N'110102', N'西城区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (4, N'110105', N'朝阳区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (5, N'110106', N'丰台区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (6, N'110107', N'石景山区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (7, N'110108', N'海淀区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (8, N'110109', N'门头沟区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (9, N'110111', N'房山区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (10, N'110112', N'通州区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (11, N'110113', N'顺义区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (12, N'110114', N'昌平区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (13, N'110115', N'大兴区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (14, N'110116', N'怀柔区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (15, N'110117', N'平谷区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (16, N'110118', N'密云区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (17, N'110119', N'延庆区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (18, N'120000', N'天津市', 0) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (19, N'120101', N'和平区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (20, N'120102', N'河东区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (21, N'120103', N'河西区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (22, N'120104', N'南开区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (23, N'120105', N'河北区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (24, N'120106', N'红桥区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (25, N'120110', N'东丽区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (26, N'120111', N'西青区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (27, N'120112', N'津南区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (28, N'120113', N'北辰区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (29, N'120114', N'武清区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (30, N'120115', N'宝坻区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (31, N'120116', N'滨海新区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (32, N'120117', N'宁河区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (33, N'120118', N'静海区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (34, N'120119', N'蓟州区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (35, N'130000', N'河北省', 0) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (36, N'130100', N'石家庄市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (37, N'130102', N'长安区', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (38, N'130104', N'桥西区', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (39, N'130105', N'新华区', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (40, N'130107', N'井陉矿区', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (41, N'130108', N'裕华区', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (42, N'130109', N'藁城区', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (43, N'130110', N'鹿泉区', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (44, N'130111', N'栾城区', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (45, N'130121', N'井陉县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (46, N'130123', N'正定县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (47, N'130125', N'行唐县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (48, N'130126', N'灵寿县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (49, N'130127', N'高邑县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (50, N'130128', N'深泽县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (51, N'130129', N'赞皇县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (52, N'130130', N'无极县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (53, N'130131', N'平山县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (54, N'130132', N'元氏县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (55, N'130133', N'赵县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (56, N'130181', N'辛集市', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (57, N'130183', N'晋州市', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (58, N'130184', N'新乐市', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (59, N'130200', N'唐山市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (60, N'130202', N'路南区', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (61, N'130203', N'路北区', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (62, N'130204', N'古冶区', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (63, N'130205', N'开平区', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (64, N'130207', N'丰南区', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (65, N'130208', N'丰润区', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (66, N'130209', N'曹妃甸区', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (67, N'130223', N'滦县', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (68, N'130224', N'滦南县', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (69, N'130225', N'乐亭县', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (70, N'130227', N'迁西县', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (71, N'130229', N'玉田县', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (72, N'130281', N'遵化市', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (73, N'130283', N'迁安市', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (74, N'130300', N'秦皇岛市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (75, N'130302', N'海港区', 74) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (76, N'130303', N'山海关区', 74) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (77, N'130304', N'北戴河区', 74) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (78, N'130306', N'抚宁区', 74) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (79, N'130321', N'青龙满族自治县', 74) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (80, N'130322', N'昌黎县', 74) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (81, N'130324', N'卢龙县', 74) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (82, N'130400', N'邯郸市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (83, N'130402', N'邯山区', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (84, N'130403', N'丛台区', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (85, N'130404', N'复兴区', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (86, N'130406', N'峰峰矿区', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (87, N'130407', N'肥乡区', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (88, N'130408', N'永年区', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (89, N'130423', N'临漳县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (90, N'130424', N'成安县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (91, N'130425', N'大名县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (92, N'130426', N'涉县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (93, N'130427', N'磁县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (94, N'130430', N'邱县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (95, N'130431', N'鸡泽县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (96, N'130432', N'广平县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (97, N'130433', N'馆陶县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (98, N'130434', N'魏县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (99, N'130435', N'曲周县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (100, N'130481', N'武安市', 82) GO INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (101, N'130500', N'邢台市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (102, N'130502', N'桥东区', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (103, N'130503', N'桥西区', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (104, N'130521', N'邢台县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (105, N'130522', N'临城县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (106, N'130523', N'内丘县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (107, N'130524', N'柏乡县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (108, N'130525', N'隆尧县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (109, N'130526', N'任县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (110, N'130527', N'南和县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (111, N'130528', N'宁晋县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (112, N'130529', N'巨鹿县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (113, N'130530', N'新河县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (114, N'130531', N'广宗县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (115, N'130532', N'平乡县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (116, N'130533', N'威县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (117, N'130534', N'清河县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (118, N'130535', N'临西县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (119, N'130581', N'南宫市', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (120, N'130582', N'沙河市', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (121, N'130600', N'保定市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (122, N'130602', N'竞秀区', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (123, N'130606', N'莲池区', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (124, N'130607', N'满城区', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (125, N'130608', N'清苑区', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (126, N'130609', N'徐水区', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (127, N'130623', N'涞水县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (128, N'130624', N'阜平县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (129, N'130626', N'定兴县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (130, N'130627', N'唐县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (131, N'130628', N'高阳县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (132, N'130629', N'容城县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (133, N'130630', N'涞源县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (134, N'130631', N'望都县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (135, N'130632', N'安新县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (136, N'130633', N'易县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (137, N'130634', N'曲阳县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (138, N'130635', N'蠡县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (139, N'130636', N'顺平县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (140, N'130637', N'博野县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (141, N'130638', N'雄县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (142, N'130681', N'涿州市', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (143, N'130682', N'定州市', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (144, N'130683', N'安国市', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (145, N'130684', N'高碑店市', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (146, N'130700', N'张家口市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (147, N'130702', N'桥东区', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (148, N'130703', N'桥西区', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (149, N'130705', N'宣化区', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (150, N'130706', N'下花园区', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (151, N'130708', N'万全区', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (152, N'130709', N'崇礼区', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (153, N'130722', N'张北县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (154, N'130723', N'康保县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (155, N'130724', N'沽源县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (156, N'130725', N'尚义县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (157, N'130726', N'蔚县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (158, N'130727', N'阳原县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (159, N'130728', N'怀安县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (160, N'130730', N'怀来县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (161, N'130731', N'涿鹿县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (162, N'130732', N'赤城县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (163, N'130800', N'承德市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (164, N'130802', N'双桥区', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (165, N'130803', N'双滦区', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (166, N'130804', N'鹰手营子矿区', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (167, N'130821', N'承德县', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (168, N'130822', N'兴隆县', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (169, N'130824', N'滦平县', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (170, N'130825', N'隆化县', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (171, N'130826', N'丰宁满族自治县', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (172, N'130827', N'宽城满族自治县', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (173, N'130828', N'围场满族蒙古族自治县', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (174, N'130881', N'平泉市', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (175, N'130900', N'沧州市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (176, N'130902', N'新华区', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (177, N'130903', N'运河区', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (178, N'130921', N'沧县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (179, N'130922', N'青县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (180, N'130923', N'东光县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (181, N'130924', N'海兴县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (182, N'130925', N'盐山县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (183, N'130926', N'肃宁县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (184, N'130927', N'南皮县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (185, N'130928', N'吴桥县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (186, N'130929', N'献县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (187, N'130930', N'孟村回族自治县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (188, N'130981', N'泊头市', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (189, N'130982', N'任丘市', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (190, N'130983', N'黄骅市', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (191, N'130984', N'河间市', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (192, N'131000', N'廊坊市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (193, N'131002', N'安次区', 192) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (194, N'131003', N'广阳区', 192) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (195, N'131022', N'固安县', 192) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (196, N'131023', N'永清县', 192) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (197, N'131024', N'香河县', 192) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (198, N'131025', N'大城县', 192) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (199, N'131026', N'文安县', 192) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (200, N'131028', N'大厂回族自治县', 192) GO