2017-5-7 三级联动数据库 数据保存

CREATE TABLE [dbo].[ChinaStates](
[AreaCode] [varchar](20) NOT NULL,
[AreaName] [nvarchar](20) NOT NULL,
[ParentAreaCode] [varchar](20) NOT NULL,
[Root] [bit] NOT NULL,
[Zone] [smallint] NOT NULL,
[NavigateURL] [varchar](100) NULL,
CONSTRAINT [PK_TB_Area] PRIMARY KEY CLUSTERED
(
[AreaCode] 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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘0001‘, N‘中国‘, N‘0000‘, 1, 0, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘11‘, N‘北京‘, N‘0001‘, 1, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1101‘, N‘北京市辖‘, N‘11‘, 1, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘110101‘, N‘东城区‘, N‘1101‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘11010101‘, N‘天安门‘, N‘110101‘, 1, 0, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘110102‘, N‘西城区‘, N‘1101‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘110103‘, N‘崇文区‘, N‘1101‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘110104‘, N‘宣武区‘, N‘1101‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘110105‘, N‘朝阳区‘, N‘1101‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘110106‘, N‘丰台区‘, N‘1101‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘110107‘, N‘石景山区‘, N‘1101‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘110108‘, N‘海淀区‘, N‘1101‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘110109‘, N‘门头沟区‘, N‘1101‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘110111‘, N‘房山区‘, N‘1101‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘110112‘, N‘通州区‘, N‘1101‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘110113‘, N‘顺义区‘, N‘1101‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘110114‘, N‘昌平区‘, N‘1101‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1102‘, N‘北京县辖‘, N‘11‘, 1, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘110224‘, N‘大兴县‘, N‘1102‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘110226‘, N‘平谷县‘, N‘1102‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘110227‘, N‘怀柔县‘, N‘1102‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘110228‘, N‘密云县‘, N‘1102‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘110229‘, N‘延庆县‘, N‘1102‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘12‘, N‘天津‘, N‘0001‘, 1, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1201‘, N‘天津市辖‘, N‘12‘, 1, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘120101‘, N‘和平区‘, N‘1201‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘120102‘, N‘河东区‘, N‘1201‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘120103‘, N‘河西区‘, N‘1201‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘120104‘, N‘南开区‘, N‘1201‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘120105‘, N‘河北区‘, N‘1201‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘120106‘, N‘红桥区‘, N‘1201‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘120107‘, N‘塘沽区‘, N‘1201‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘120108‘, N‘汉沽区‘, N‘1201‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘120109‘, N‘大港区‘, N‘1201‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘120110‘, N‘东丽区‘, N‘1201‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘120111‘, N‘西青区‘, N‘1201‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘120112‘, N‘津南区‘, N‘1201‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘120113‘, N‘北辰区‘, N‘1201‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘120114‘, N‘武清区‘, N‘1201‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1202‘, N‘天津县辖‘, N‘12‘, 1, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘120221‘, N‘宁河县‘, N‘1202‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘120223‘, N‘静海县‘, N‘1202‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘120224‘, N‘宝坻县‘, N‘1202‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘120225‘, N‘蓟 县‘, N‘1202‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘13‘, N‘河北‘, N‘0001‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1301‘, N‘石家庄‘, N‘13‘, 1, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130101‘, N‘市辖区‘, N‘1301‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130102‘, N‘长安区‘, N‘1301‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130103‘, N‘桥东区‘, N‘1301‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130104‘, N‘桥西区‘, N‘1301‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130105‘, N‘新华区‘, N‘1301‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130106‘, N‘郊 区‘, N‘1301‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130107‘, N‘井陉矿区‘, N‘1301‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130121‘, N‘井陉县‘, N‘1301‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130123‘, N‘正定县‘, N‘1301‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130124‘, N‘栾城县‘, N‘1301‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130125‘, N‘行唐县‘, N‘1301‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130126‘, N‘灵寿县‘, N‘1301‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130127‘, N‘高邑县‘, N‘1301‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130128‘, N‘深泽县‘, N‘1301‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130129‘, N‘赞皇县‘, N‘1301‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130130‘, N‘无极县‘, N‘1301‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130131‘, N‘平山县‘, N‘1301‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130132‘, N‘元氏县‘, N‘1301‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130133‘, N‘赵 县‘, N‘1301‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130181‘, N‘辛集市‘, N‘1301‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130182‘, N‘藁城市‘, N‘1301‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130183‘, N‘晋州市‘, N‘1301‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130184‘, N‘新乐市‘, N‘1301‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130185‘, N‘鹿泉市‘, N‘1301‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1302‘, N‘唐山‘, N‘13‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130201‘, N‘市辖区‘, N‘1302‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130202‘, N‘路南区‘, N‘1302‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130203‘, N‘路北区‘, N‘1302‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130204‘, N‘古冶区‘, N‘1302‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130205‘, N‘开平区‘, N‘1302‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130206‘, N‘新 区‘, N‘1302‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130221‘, N‘丰润县‘, N‘1302‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130223‘, N‘滦 县‘, N‘1302‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130224‘, N‘滦南县‘, N‘1302‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130225‘, N‘乐亭县‘, N‘1302‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130227‘, N‘迁西县‘, N‘1302‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130229‘, N‘玉田县‘, N‘1302‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130230‘, N‘唐海县‘, N‘1302‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130281‘, N‘遵化市‘, N‘1302‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130282‘, N‘丰南市‘, N‘1302‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130283‘, N‘迁安市‘, N‘1302‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1303‘, N‘秦皇岛‘, N‘13‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130301‘, N‘市辖区‘, N‘1303‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130302‘, N‘海港区‘, N‘1303‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130303‘, N‘山海关区‘, N‘1303‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130304‘, N‘北戴河区‘, N‘1303‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130321‘, N‘青龙满族自治县‘, N‘1303‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130322‘, N‘昌黎县‘, N‘1303‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130323‘, N‘抚宁县‘, N‘1303‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130324‘, N‘卢龙县‘, N‘1303‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1304‘, N‘邯郸‘, N‘13‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130401‘, N‘市辖区‘, N‘1304‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130402‘, N‘邯山区‘, N‘1304‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130403‘, N‘丛台区‘, N‘1304‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130404‘, N‘复兴区‘, N‘1304‘, 0, 2, NULL)
GO
print ‘Processed 100 total records‘
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130406‘, N‘峰峰矿区‘, N‘1304‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130421‘, N‘邯郸县‘, N‘1304‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130423‘, N‘临漳县‘, N‘1304‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130424‘, N‘成安县‘, N‘1304‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130425‘, N‘大名县‘, N‘1304‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130426‘, N‘涉 县‘, N‘1304‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130427‘, N‘磁 县‘, N‘1304‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130428‘, N‘肥乡县‘, N‘1304‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130429‘, N‘永年县‘, N‘1304‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130430‘, N‘邱 县‘, N‘1304‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130431‘, N‘鸡泽县‘, N‘1304‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130432‘, N‘广平县‘, N‘1304‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130433‘, N‘馆陶县‘, N‘1304‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130434‘, N‘魏 县‘, N‘1304‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130435‘, N‘曲周县‘, N‘1304‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130481‘, N‘武安市‘, N‘1304‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1305‘, N‘邢台‘, N‘13‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130501‘, N‘市辖区‘, N‘1305‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130502‘, N‘桥东区‘, N‘1305‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130503‘, N‘桥西区‘, N‘1305‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130521‘, N‘邢台县‘, N‘1305‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130522‘, N‘临城县‘, N‘1305‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130523‘, N‘内丘县‘, N‘1305‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130524‘, N‘柏乡县‘, N‘1305‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130525‘, N‘隆尧县‘, N‘1305‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130526‘, N‘任 县‘, N‘1305‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130527‘, N‘南和县‘, N‘1305‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130528‘, N‘宁晋县‘, N‘1305‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130529‘, N‘巨鹿县‘, N‘1305‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130530‘, N‘新河县‘, N‘1305‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130531‘, N‘广宗县‘, N‘1305‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130532‘, N‘平乡县‘, N‘1305‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130533‘, N‘威 县‘, N‘1305‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130534‘, N‘清河县‘, N‘1305‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130535‘, N‘临西县‘, N‘1305‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130581‘, N‘南宫市‘, N‘1305‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130582‘, N‘沙河市‘, N‘1305‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1306‘, N‘保定‘, N‘13‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130601‘, N‘市辖区‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130602‘, N‘新市区‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130603‘, N‘北市区‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130604‘, N‘南市区‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130621‘, N‘满城县‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130622‘, N‘清苑县‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130623‘, N‘涞水县‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130624‘, N‘阜平县‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130625‘, N‘徐水县‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130626‘, N‘定兴县‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130627‘, N‘唐 县‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130628‘, N‘高阳县‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130629‘, N‘容城县‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130630‘, N‘涞源县‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130631‘, N‘望都县‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130632‘, N‘安新县‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130633‘, N‘易 县‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130634‘, N‘曲阳县‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130635‘, N‘蠡 县‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130636‘, N‘顺平县‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130637‘, N‘博野县‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130638‘, N‘雄 县‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130681‘, N‘涿州市‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130682‘, N‘定州市‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130683‘, N‘安国市‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130684‘, N‘高碑店市‘, N‘1306‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1307‘, N‘张家口‘, N‘13‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130701‘, N‘市辖区‘, N‘1307‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130702‘, N‘桥东区‘, N‘1307‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130703‘, N‘桥西区‘, N‘1307‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130705‘, N‘宣化区‘, N‘1307‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130706‘, N‘下花园区‘, N‘1307‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130721‘, N‘宣化县‘, N‘1307‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130722‘, N‘张北县‘, N‘1307‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130723‘, N‘康保县‘, N‘1307‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130724‘, N‘沽源县‘, N‘1307‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130725‘, N‘尚义县‘, N‘1307‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130726‘, N‘蔚 县‘, N‘1307‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130727‘, N‘阳原县‘, N‘1307‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130728‘, N‘怀安县‘, N‘1307‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130729‘, N‘万全县‘, N‘1307‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130730‘, N‘怀来县‘, N‘1307‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130731‘, N‘涿鹿县‘, N‘1307‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130732‘, N‘赤城县‘, N‘1307‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130733‘, N‘崇礼县‘, N‘1307‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1308‘, N‘承德‘, N‘13‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130801‘, N‘市辖区‘, N‘1308‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130802‘, N‘双桥区‘, N‘1308‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130803‘, N‘双滦区‘, N‘1308‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130804‘, N‘鹰手营子矿区‘, N‘1308‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130821‘, N‘承德县‘, N‘1308‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130822‘, N‘兴隆县‘, N‘1308‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130823‘, N‘平泉县‘, N‘1308‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130824‘, N‘滦平县‘, N‘1308‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130825‘, N‘隆化县‘, N‘1308‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130826‘, N‘丰宁满族自治县‘, N‘1308‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130827‘, N‘宽城满族自治县‘, N‘1308‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130828‘, N‘围场满族蒙古族自治县‘, N‘1308‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1309‘, N‘沧州‘, N‘13‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130901‘, N‘市辖区‘, N‘1309‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130902‘, N‘新华区‘, N‘1309‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130903‘, N‘运河区‘, N‘1309‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130921‘, N‘沧 县‘, N‘1309‘, 0, 2, NULL)
GO
print ‘Processed 200 total records‘
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130922‘, N‘青 县‘, N‘1309‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130923‘, N‘东光县‘, N‘1309‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130924‘, N‘海兴县‘, N‘1309‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130925‘, N‘盐山县‘, N‘1309‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130926‘, N‘肃宁县‘, N‘1309‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130927‘, N‘南皮县‘, N‘1309‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130928‘, N‘吴桥县‘, N‘1309‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130929‘, N‘献 县‘, N‘1309‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130930‘, N‘孟村回族自治县‘, N‘1309‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130981‘, N‘泊头市‘, N‘1309‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130982‘, N‘任丘市‘, N‘1309‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130983‘, N‘黄骅市‘, N‘1309‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘130984‘, N‘河间市‘, N‘1309‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1310‘, N‘廊坊‘, N‘13‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘131001‘, N‘市辖区‘, N‘1310‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘131002‘, N‘安次区‘, N‘1310‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘131003‘, N‘廊坊市广阳区‘, N‘1310‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘131022‘, N‘固安县‘, N‘1310‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘131023‘, N‘永清县‘, N‘1310‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘131024‘, N‘香河县‘, N‘1310‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘131025‘, N‘大城县‘, N‘1310‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘131026‘, N‘文安县‘, N‘1310‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘131028‘, N‘大厂回族自治县‘, N‘1310‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘131081‘, N‘霸州市‘, N‘1310‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘131082‘, N‘三河市‘, N‘1310‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1311‘, N‘衡水‘, N‘13‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘131101‘, N‘市辖区‘, N‘1311‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘131102‘, N‘桃城区‘, N‘1311‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘131121‘, N‘枣强县‘, N‘1311‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘131122‘, N‘武邑县‘, N‘1311‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘131123‘, N‘武强县‘, N‘1311‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘131124‘, N‘饶阳县‘, N‘1311‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘131125‘, N‘安平县‘, N‘1311‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘131126‘, N‘故城县‘, N‘1311‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘131127‘, N‘景 县‘, N‘1311‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘131128‘, N‘阜城县‘, N‘1311‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘131181‘, N‘冀州市‘, N‘1311‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘131182‘, N‘深州市‘, N‘1311‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘14‘, N‘山西‘, N‘0001‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1401‘, N‘太原‘, N‘14‘, 1, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140101‘, N‘市辖区‘, N‘1401‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140105‘, N‘小店区‘, N‘1401‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140106‘, N‘迎泽区‘, N‘1401‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140107‘, N‘杏花岭区‘, N‘1401‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140108‘, N‘尖草坪区‘, N‘1401‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140109‘, N‘万柏林区‘, N‘1401‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140110‘, N‘晋源区‘, N‘1401‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140121‘, N‘清徐县‘, N‘1401‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140122‘, N‘阳曲县‘, N‘1401‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140123‘, N‘娄烦县‘, N‘1401‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140181‘, N‘古交市‘, N‘1401‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1402‘, N‘大同‘, N‘14‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140201‘, N‘市辖区‘, N‘1402‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140202‘, N‘城 区‘, N‘1402‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140203‘, N‘矿 区‘, N‘1402‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140211‘, N‘南郊区‘, N‘1402‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140212‘, N‘新荣区‘, N‘1402‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140221‘, N‘阳高县‘, N‘1402‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140222‘, N‘天镇县‘, N‘1402‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140223‘, N‘广灵县‘, N‘1402‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140224‘, N‘灵丘县‘, N‘1402‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140225‘, N‘浑源县‘, N‘1402‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140226‘, N‘左云县‘, N‘1402‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140227‘, N‘大同县‘, N‘1402‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1403‘, N‘阳泉‘, N‘14‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140301‘, N‘市辖区‘, N‘1403‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140302‘, N‘城 区‘, N‘1403‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140303‘, N‘矿 区‘, N‘1403‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140311‘, N‘郊 区‘, N‘1403‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140321‘, N‘平定县‘, N‘1403‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140322‘, N‘盂 县‘, N‘1403‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1404‘, N‘长治‘, N‘14‘, 1, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140401‘, N‘市辖区‘, N‘1404‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140402‘, N‘城 区‘, N‘1404‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140411‘, N‘郊 区‘, N‘1404‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140421‘, N‘长治县‘, N‘1404‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140423‘, N‘襄垣县‘, N‘1404‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140424‘, N‘屯留县‘, N‘1404‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140425‘, N‘平顺县‘, N‘1404‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140426‘, N‘黎城县‘, N‘1404‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140427‘, N‘壶关县‘, N‘1404‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140428‘, N‘长子县‘, N‘1404‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140429‘, N‘武乡县‘, N‘1404‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140430‘, N‘沁 县‘, N‘1404‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140431‘, N‘沁源县‘, N‘1404‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140481‘, N‘潞城市‘, N‘1404‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1405‘, N‘晋城‘, N‘14‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140501‘, N‘市辖区‘, N‘1405‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140502‘, N‘城 区‘, N‘1405‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140521‘, N‘沁水县‘, N‘1405‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140522‘, N‘阳城县‘, N‘1405‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140524‘, N‘陵川县‘, N‘1405‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140525‘, N‘泽州县‘, N‘1405‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140581‘, N‘高平市‘, N‘1405‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1406‘, N‘朔州‘, N‘14‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140601‘, N‘市辖区‘, N‘1406‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140602‘, N‘朔城区‘, N‘1406‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140603‘, N‘平鲁区‘, N‘1406‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140621‘, N‘山阴县‘, N‘1406‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140622‘, N‘应 县‘, N‘1406‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140623‘, N‘右玉县‘, N‘1406‘, 0, 2, NULL)
GO
print ‘Processed 300 total records‘
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140624‘, N‘怀仁县‘, N‘1406‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1407‘, N‘晋中‘, N‘14‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140701‘, N‘市辖区‘, N‘1407‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140702‘, N‘榆次区‘, N‘1407‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140721‘, N‘榆社县‘, N‘1407‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140722‘, N‘左权县‘, N‘1407‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140723‘, N‘和顺县‘, N‘1407‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140724‘, N‘昔阳县‘, N‘1407‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140725‘, N‘寿阳县‘, N‘1407‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140726‘, N‘太谷县‘, N‘1407‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140727‘, N‘祁 县‘, N‘1407‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140728‘, N‘平遥县‘, N‘1407‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140729‘, N‘灵石县‘, N‘1407‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140781‘, N‘介休市‘, N‘1407‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1408‘, N‘运城‘, N‘14‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140801‘, N‘市辖区‘, N‘1408‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140802‘, N‘盐湖区‘, N‘1408‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140821‘, N‘临猗县‘, N‘1408‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140822‘, N‘万荣县‘, N‘1408‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140823‘, N‘闻喜县‘, N‘1408‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140824‘, N‘稷山县‘, N‘1408‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140825‘, N‘新绛县‘, N‘1408‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140826‘, N‘绛 县‘, N‘1408‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140827‘, N‘垣曲县‘, N‘1408‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140828‘, N‘夏 县‘, N‘1408‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140829‘, N‘平陆县‘, N‘1408‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140830‘, N‘芮城县‘, N‘1408‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140881‘, N‘永济市‘, N‘1408‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140882‘, N‘河津市‘, N‘1408‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1409‘, N‘忻州‘, N‘14‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140901‘, N‘市辖区‘, N‘1409‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140902‘, N‘忻府区‘, N‘1409‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140921‘, N‘定襄县‘, N‘1409‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140922‘, N‘五台县‘, N‘1409‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140923‘, N‘代 县‘, N‘1409‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140924‘, N‘繁峙县‘, N‘1409‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140925‘, N‘宁武县‘, N‘1409‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140926‘, N‘静乐县‘, N‘1409‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140927‘, N‘神池县‘, N‘1409‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140928‘, N‘五寨县‘, N‘1409‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140929‘, N‘岢岚县‘, N‘1409‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140930‘, N‘河曲县‘, N‘1409‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140931‘, N‘保德县‘, N‘1409‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140932‘, N‘偏关县‘, N‘1409‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘140981‘, N‘原平市‘, N‘1409‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1410‘, N‘临汾‘, N‘14‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘141001‘, N‘市辖区‘, N‘1410‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘141002‘, N‘尧都区‘, N‘1410‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘141021‘, N‘曲沃县‘, N‘1410‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘141022‘, N‘翼城县‘, N‘1410‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘141023‘, N‘襄汾县‘, N‘1410‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘141024‘, N‘洪洞县‘, N‘1410‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘141025‘, N‘古 县‘, N‘1410‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘141026‘, N‘安泽县‘, N‘1410‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘141027‘, N‘浮山县‘, N‘1410‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘141028‘, N‘吉 县‘, N‘1410‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘141029‘, N‘乡宁县‘, N‘1410‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘141030‘, N‘大宁县‘, N‘1410‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘141031‘, N‘隰 县‘, N‘1410‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘141032‘, N‘永和县‘, N‘1410‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘141033‘, N‘蒲 县‘, N‘1410‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘141034‘, N‘汾西县‘, N‘1410‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘141081‘, N‘侯马市‘, N‘1410‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘141082‘, N‘霍州市‘, N‘1410‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘1423‘, N‘吕梁地区‘, N‘14‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘142301‘, N‘孝义市‘, N‘1423‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘142302‘, N‘离石市‘, N‘1423‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘142303‘, N‘汾阳市‘, N‘1423‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘142322‘, N‘文水县‘, N‘1423‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘142323‘, N‘交城县‘, N‘1423‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘142325‘, N‘兴 县‘, N‘1423‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘142326‘, N‘临 县‘, N‘1423‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘142327‘, N‘柳林县‘, N‘1423‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘142328‘, N‘石楼县‘, N‘1423‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘142329‘, N‘岚 县‘, N‘1423‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘142330‘, N‘方山县‘, N‘1423‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘142332‘, N‘中阳县‘, N‘1423‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘142333‘, N‘交口县‘, N‘1423‘, 0, 2, NULL)
INSERT [dbo].[ChinaStates] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL]) VALUES (N‘15‘, N‘内蒙古‘, N‘0