中国省市区数据库 含中英繁对照SQL

以下省市区地理位置数据为在日常使用过程中整理获得，部分数据无英文字段，若需使用，可以直接拷贝以下代码本地执行后，按需筛选或补充自己的数据信息，将产生的表为：Province，City，Prefectures

GO

/****** Object: Table [dbo].[Province] Script Date: 06/12/2018 18:02:25 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE[dbo].[Province](

[ProvinceId][bigint]NOT NULL,

[CountryId][bigint]NOT NULL,

[ChiName][nvarchar](256)NOT NULL,

[EngName][nvarchar](256)NULL,

[NameTra][nvarchar](512)NULL,

[LastUpdateTime][datetime]NOT NULL,

[AddTime][datetime]NOT NULL,

[ProvinceSort][int]NULL,

[ProvinceRemark][nvarchar](50)NULL,

CONSTRAINT[PK_Province]PRIMARY KEY CLUSTERED

(

[ProvinceId]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

EXEC sys.sp_addextendedproperty@name=N'MS_Description',@value=N'所属国家',

@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'Province',

@level2type=N'COLUMN',@level2name=N'CountryId'

GO

EXEC sys.sp_addextendedproperty@name=N'MS_Description',@value=N'中文名称',

@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'Province',

@level2type=N'COLUMN',@level2name=N'ChiName'

GO

EXEC sys.sp_addextendedproperty@name=N'MS_Description',@value=N'英文名称',

@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'Province',

@level2type=N'COLUMN',@level2name=N'EngName'

GO

EXEC sys.sp_addextendedproperty@name=N'MS_Description',@value=N'最后更新时间',

@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'Province',

@level2type=N'COLUMN',@level2name=N'LastUpdateTime'

GO

EXEC sys.sp_addextendedproperty@name=N'MS_Description',@value=N'添加时间',

@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'Province',

@level2type=N'COLUMN',@level2name=N'AddTime'

GO

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (1,1,N'北京市',N'Beijing', N'北京市',CAST(0x0000A516013B3028 AS DateTime),CAST(0x0000A516013B3028 AS DateTime), 1,N'直辖市')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (2,1,N'天津市',N'Tianjin', N'天津市',CAST(0x0000A516013B3029 AS DateTime),CAST(0x0000A516013B3029 AS DateTime), 2,N'直辖市')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (3, 1,N'河北省',N'Hebei', N'河北省',CAST(0x0000A516013B3029 AS DateTime),CAST(0x0000A516013B3029 AS DateTime), 5,N'省份') INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (4, 1,N'山西省',N'Shanxi', N'山西省',CAST(0x0000A516013B302A AS DateTime),CAST(0x0000A516013B302A AS DateTime), 6,N'省份') INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (5,1,N'内蒙古自治区',N'Inner Mongoria',N'内蒙古自治区',CAST(0x0000A516013B302A AS DateTime),CAST(0x0000A516013B302A AS DateTime), 32,N'自治区')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (6,1,N'辽宁省',N'Liaoning',

N'辽宁省',CAST(0x0000A516013B302A AS DateTime),CAST(0x0000A516013B302A AS DateTime), 8,N'省份') INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (7, 1,N'吉林省',N'Jilin', N'吉林省',CAST(0x0000A516013B302A AS DateTime),CAST(0x0000A516013B302A AS DateTime), 9,N'省份') INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (8, 1,N'黑龙江省',

N'Heilongjiang',N'黑龙江省',CAST(0x0000A516013B302A AS DateTime),CAST(0x0000A516013B302A AS DateTime), 10,N'省份')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (9,1,N'上海市',N'Shanghai', N'上海市',CAST(0x0000A516013B302A AS DateTime),CAST(0x0000A516013B302A AS DateTime), 3,N'直辖市')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (10,1,N'江苏省',N'Jiangsu', N'江苏省',CAST(0x0000A516013B302A AS DateTime),CAST(0x0000A516013B302A AS DateTime), 11,N'省份')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (11,1,N'浙江省',N'Zhejiang', N'浙江省',CAST(0x0000A516013B302A AS DateTime),CAST(0x0000A516013B302A AS DateTime), 12,N'省份')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (12, 1,N'安徽省',N'Anhui', N'安徽省',CAST(0x0000A516013B302A AS DateTime),CAST(0x0000A516013B302A AS DateTime), 13,N'省份')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (13,1,N'福建省',N'Fujian', N'福建省',CAST(0x0000A516013B302A AS DateTime),CAST(0x0000A516013B302A AS DateTime), 14,N'省份')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (14,1,N'江西省',N'Jiangxi', N'江西省',CAST(0x0000A516013B302B AS DateTime),CAST(0x0000A516013B302B AS DateTime), 15,N'省份')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (15,1,N'山东省',N'Shandong', N'山东省',CAST(0x0000A516013B302B AS DateTime),CAST(0x0000A516013B302B AS DateTime), 16,N'省份')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (16, 1,N'河南省',N'Henan', N'河南省',CAST(0x0000A516013B302B AS DateTime),CAST(0x0000A516013B302B AS DateTime), 17,N'省份')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (17, 1,N'湖北省',N'Hubei', N'湖北省',CAST(0x0000A516013B302C AS DateTime),CAST(0x0000A516013B302C AS DateTime), 18,N'省份')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (18, 1,N'湖南省',N'Hunan', N'湖南省',CAST(0x0000A516013B302C AS DateTime),CAST(0x0000A516013B302C AS DateTime), 19,N'省份')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (19,1,N'广东省',N'Guangdong', N'广东省',CAST(0x0000A516013B302C AS DateTime),CAST(0x0000A516013B302C AS DateTime), 20,N'省份')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (20,1,N'海南省',N'Hainan', N'海南省',CAST(0x0000A516013B302C AS DateTime),CAST(0x0000A516013B302C AS DateTime), 24,N'省份')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (21, 1,N'广西壮族自治区',

N'Guangxi',N'广西壮族自治区',CAST(0x0000A516013B302C AS DateTime),CAST(0x0000A516013B302C AS DateTime), 28,N'自治区')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (22, 1,N'甘肃省',N'Gansu', N'甘肃省',CAST(0x0000A516013B302D AS DateTime),CAST(0x0000A516013B302D AS DateTime), 21,N'省份')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (23,1,N'陕西省',N'Shaanxi', N'陕西省',CAST(0x0000A516013B302D AS DateTime),CAST(0x0000A516013B302D AS DateTime), 27,N'省份')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (24, 1,N'新疆维吾尔自治区',

N'Xinjiang',N'新疆维吾尔自治区',CAST(0x0000A516013B302D AS DateTime),CAST(0x0000A516013B302D AS DateTime), 31,N'自治区')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (25,1,N'青海省',N'Qinghai', N'青海省',CAST(0x0000A516013B302D AS DateTime),CAST(0x0000A516013B302D AS DateTime), 26,N'省份')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (26, 1,N'宁夏回族自治区',

N'Ningxia',N'宁夏回族自治区',CAST(0x0000A516013B302D AS DateTime),CAST(0x0000A516013B302D AS DateTime), 30,N'自治区')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (27,1,N'重庆市',N'Chongqing', N'重庆市',CAST(0x0000A516013B302D AS DateTime),CAST(0x0000A516013B302D AS DateTime), 4,N'直辖市')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (28,1,N'四川省',N'Sichuan', N'四川省',CAST(0x0000A516013B302D AS DateTime),CAST(0x0000A516013B302D AS DateTime), 22,N'省份')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (29,1,N'贵州省',N'Guizhou', N'贵州省',CAST(0x0000A516013B302D AS DateTime),CAST(0x0000A516013B302D AS DateTime), 23,N'省份')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (30,1,N'云南省',N'Yunnan', N'云南省',CAST(0x0000A516013B302D AS DateTime),CAST(0x0000A516013B302D AS DateTime), 25,N'省份')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (31,1,N'西藏自治区',N'Tibet', N'西藏自治区',CAST(0x0000A516013B302D AS DateTime),CAST(0x0000A516013B302D AS DateTime), 29,N'自治区')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (32,1,N'台湾省',N'Taiwan', N'台湾省',CAST(0x0000A516013B302D AS DateTime),CAST(0x0000A516013B302D AS DateTime), 7,N'省份') INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (33, 1,N'澳门特别行政区',

N'Macao',N'澳门特别行政区',CAST(0x0000A516013B302E AS DateTime),CAST(0x0000A516013B302E AS DateTime), 33,N'特别行政区')

INSERT[dbo].[Province]([ProvinceId],[CountryId],[ChiName],[EngName],[NameTra], [LastUpdateTime],[AddTime],[ProvinceSort],[ProvinceRemark])VALUES (34, 1,N'香港特别行政区',

N'Hong Kong',N'香港特別行政區',CAST(0x0000A516013B302E AS DateTime),CAST(0x0000A516013B302E AS DateTime), 34,N'特别行政区')

/****** Object: Table [dbo].[Prefectures] Script Date: 06/12/2018 18:02:25 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE[dbo].[Prefectures](

[PrefecturesId][bigint]NOT NULL,

[CityId][bigint]NOT NULL,

[ChiName][nvarchar](512)NOT NULL,

[EngName][nvarchar](512)NULL,

[NameTra][nvarchar](512)NULL,

[PostalCode][nvarchar](50)NULL,

[IsDel][bit]NOT NULL,

[LastUpdateTime][datetime]NOT NULL,

[AddTime][datetime]NULL,

[PrefecturesSort][int]NULL,

CONSTRAINT[PK_Prefectures]PRIMARY KEY CLUSTERED

(

[PrefecturesId]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

EXEC sys.sp_addextendedproperty@name=N'MS_Description',@value=N'所属城市',

@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'Prefectures',

@level2type=N'COLUMN',@level2name=N'CityId'

GO

EXEC sys.sp_addextendedproperty@name=N'MS_Description',@value=N'中文名称',

@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'Prefectures',

@level2type=N'COLUMN',@level2name=N'ChiName'

GO

EXEC sys.sp_addextendedproperty@name=N'MS_Description',@value=N'英文名称',

@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'Prefectures',

@level2type=N'COLUMN',@level2name=N'EngName'

GO

EXEC sys.sp_addextendedproperty@name=N'MS_Description',@value=N'邮政编码',

@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'Prefectures',

@level2type=N'COLUMN',@level2name=N'PostalCode'

GO

EXEC sys.sp_addextendedproperty@name=N'MS_Description',@value=N'最后更新时间',

@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'Prefectures',

@level2type=N'COLUMN',@level2name=N'LastUpdateTime'

GO

EXEC sys.sp_addextendedproperty@name=N'MS_Description',@value=N'添加时间',

@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'Prefectures',

@level2type=N'COLUMN',@level2name=N'AddTime'

GO

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (1, 1,N'东城区',N'Dongcheng',N'东城区',NULL,0,CAST(0x0000A5160141FAB9 AS DateTime),CAST(0x0000A5160141FAB9 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (2, 1,N'西城区',N'Xicheng',N'

西城区',NULL,0,CAST(0x0000A5160141FABC AS DateTime),CAST(0x0000A5160141FABC AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (3, 1,N'崇文区',NULL,N'崇文区', NULL, 0,CAST(0x0000A5160141FABC AS DateTime),CAST(0x0000A5160141FABC AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (4, 1,N'宣武区',NULL,N'宣武区', NULL, 0,CAST(0x0000A5160141FABC AS DateTime),CAST(0x0000A5160141FABC AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (5, 1,N'朝阳区',N'Chaoyang',N'朝阳区',NULL,0,CAST(0x0000A5160141FABC AS DateTime),CAST(0x0000A5160141FABC AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (6, 1,N'丰台区',N'Fengtai',N'

丰台区',NULL,0,CAST(0x0000A5160141FABC AS DateTime),CAST(0x0000A5160141FABC AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (7,1,N'石景山区',N'Shijingshan', N'石景山区',NULL, 0,CAST(0x0000A5160141FABC AS DateTime),CAST(0x0000A5160141FABC AS DateTime), NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (8, 1,N'海淀区',N'Haidian',N'

海淀区',NULL,0,CAST(0x0000A5160141FABC AS DateTime),CAST(0x0000A5160141FABC AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (9,1,N'门头沟区',N'Mentougou',N'门头沟区',NULL,0,CAST(0x0000A5160141FABC AS DateTime),CAST(0x0000A5160141FABC AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (10, 1,N'房山区',N'Fangshan',N'房山区',NULL,0,CAST(0x0000A5160141FABD AS DateTime),CAST(0x0000A5160141FABD AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (11, 1,N'通州区',N'Tongzhou',N'通州区',NULL,0,CAST(0x0000A5160141FABD AS DateTime),CAST(0x0000A5160141FABD AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (12, 1,N'顺义区',N'Shunyi',N'

顺义区',NULL,0,CAST(0x0000A5160141FABD AS DateTime),CAST(0x0000A5160141FABD AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (13,1,N'昌平区',N'Changping',N'昌平区',NULL,0,CAST(0x0000A5160141FABE AS DateTime),CAST(0x0000A5160141FABE AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (14, 1,N'大兴区',N'Daxing',N'

大兴区',NULL,0,CAST(0x0000A5160141FABE AS DateTime),CAST(0x0000A5160141FABE AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (15, 1,N'怀柔区',N'Huairou',N'怀柔区',NULL,0,CAST(0x0000A5160141FABE AS DateTime),CAST(0x0000A5160141FABE AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (16, 1,N'平谷区',N'Pinggu',N'

平谷区',NULL,0,CAST(0x0000A5160141FABE AS DateTime),CAST(0x0000A5160141FABE AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (17, 1,N'密云县',N'Miyun',N'密云县',NULL, 0,CAST(0x0000A5160141FABF AS DateTime),CAST(0x0000A5160141FABF AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode],

延庆县',NULL,0,CAST(0x0000A5160141FABF AS DateTime),CAST(0x0000A5160141FABF AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (19, 2,N'和平区',N'Heping',N'

和平区',NULL,0,CAST(0x0000A5160141FABF AS DateTime),CAST(0x0000A5160141FABF AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (20, 2,N'河东区',N'Hedong',N'

河东区',NULL,0,CAST(0x0000A5160141FABF AS DateTime),CAST(0x0000A5160141FABF AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (21, 2,N'河西区',N'Hexi',N'河西区',NULL, 0,CAST(0x0000A5160141FABF AS DateTime),CAST(0x0000A5160141FABF AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (22, 2,N'南开区',N'Nankai',N'

南开区',NULL,0,CAST(0x0000A5160141FABF AS DateTime),CAST(0x0000A5160141FABF AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (23, 2,N'河北区',N'Hebei',N'河北区',NULL, 0,CAST(0x0000A5160141FAC0 AS DateTime),CAST(0x0000A5160141FAC0 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (24, 2,N'红桥区',N'Hongqiao',N'红桥区',NULL,0,CAST(0x0000A5160141FAC0 AS DateTime),CAST(0x0000A5160141FAC0 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (25, 2,N'塘沽区',NULL,N'塘沽区',NULL, 0,CAST(0x0000A5160141FAC0 AS DateTime),CAST(0x0000A5160141FAC0 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (26, 2,N'汉沽区',NULL,N'汉沽区',NULL, 0,CAST(0x0000A5160141FAC0 AS DateTime),CAST(0x0000A5160141FAC0 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (27, 2,N'大港区',NULL,N'大港区',NULL, 0,CAST(0x0000A5160141FAC0 AS DateTime),CAST(0x0000A5160141FAC0 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (28, 2,N'东丽区',N'Dongli',N'

东丽区',NULL,0,CAST(0x0000A5160141FAC0 AS DateTime),CAST(0x0000A5160141FAC0 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (29, 2,N'西青区',N'Xiqing',N'

西青区',NULL,0,CAST(0x0000A5160141FAC0 AS DateTime),CAST(0x0000A5160141FAC0 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (30, 2,N'津南区',N'Jinnan',N'

津南区',NULL,0,CAST(0x0000A5160141FAC0 AS DateTime),CAST(0x0000A5160141FAC0 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (31, 2,N'北辰区',N'Beichen',N'北辰区',NULL,0,CAST(0x0000A5160141FAC1 AS DateTime),CAST(0x0000A5160141FAC1 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (32, 2,N'武清区',N'Wuqing',N'

武清区',NULL,0,CAST(0x0000A5160141FAC1 AS DateTime),CAST(0x0000A5160141FAC1 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (33, 2,N'宝坻区',N'Baodi',N'宝坻区',NULL, 0,CAST(0x0000A5160141FAC1 AS DateTime),CAST(0x0000A5160141FAC1 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (34, 2,N'宁河县',N'Ninghe',N'

宁河县',NULL,0,CAST(0x0000A5160141FAC1 AS DateTime),CAST(0x0000A5160141FAC1 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (35, 2,N'静海县',N'Jinghai',N'静海县',NULL,0,CAST(0x0000A5160141FAC1 AS DateTime),CAST(0x0000A5160141FAC1 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (36,2,N'蓟县',NULL,N'蓟县',NULL, 0,CAST(0x0000A5160141FAC1 AS DateTime),CAST(0x0000A5160141FAC1 AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (37, 3,N'黄浦区',N'Huangpu',N'黄浦区',NULL,0,CAST(0x0000A5160141FAC1 AS DateTime),CAST(0x0000A5160141FAC1 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (38, 3,N'卢湾区',NULL,N'卢湾区',NULL, 0,CAST(0x0000A5160141FAC1 AS DateTime),CAST(0x0000A5160141FAC1 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (39, 3,N'徐汇区',N'Xuhui',N'徐汇区',NULL, 0,CAST(0x0000A5160141FAC2 AS DateTime),CAST(0x0000A5160141FAC2 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (40,3,N'长宁区',N'Changning',N'长宁区',NULL,0,CAST(0x0000A5160141FAC2 AS DateTime),CAST(0x0000A5160141FAC2 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode],

静安区',NULL,0,CAST(0x0000A5160141FAC2 AS DateTime),CAST(0x0000A5160141FAC2 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (42, 3,N'普陀区',N'Putuo',N'普陀区',NULL, 0,CAST(0x0000A5160141FAC2 AS DateTime),CAST(0x0000A5160141FAC2 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (43, 3,N'闸北区',NULL,N'闸北区',NULL, 0,CAST(0x0000A5160141FAC2 AS DateTime),CAST(0x0000A5160141FAC2 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (44, 3,N'虹口区',N'Hongkou',N'虹口区',NULL,0,CAST(0x0000A5160141FAC2 AS DateTime),CAST(0x0000A5160141FAC2 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (45, 3,N'杨浦区',N'Yangpu',N'

杨浦区',NULL,0,CAST(0x0000A5160141FAC2 AS DateTime),CAST(0x0000A5160141FAC2 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (46, 3,N'闵行区',N'Minhang',N'闵行区',NULL,0,CAST(0x0000A5160141FAC2 AS DateTime),CAST(0x0000A5160141FAC2 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (47, 3,N'宝山区',N'Baoshan',N'宝山区',NULL,0,CAST(0x0000A5160141FAC3 AS DateTime),CAST(0x0000A5160141FAC3 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (48, 3,N'嘉定区',N'Jiading',N'嘉定区',NULL,0,CAST(0x0000A5160141FAC3 AS DateTime),CAST(0x0000A5160141FAC3 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (49, 3,N'浦东新区',N'Pudong',N'浦东新区',NULL,0,CAST(0x0000A5160141FAC3 AS DateTime),CAST(0x0000A5160141FAC3 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (50, 3,N'金山区',N'Jinshan',N'金山区',NULL,0,CAST(0x0000A5160141FAC3 AS DateTime),CAST(0x0000A5160141FAC3 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (51,3,N'松江区',N'Songjiang',N'松江区',NULL,0,CAST(0x0000A5160141FAC3 AS DateTime),CAST(0x0000A5160141FAC3 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (52, 3,N'青浦区',N'Qingpu',N'

青浦区',NULL,0,CAST(0x0000A5160141FAC3 AS DateTime),CAST(0x0000A5160141FAC3 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (53, 3,N'南汇区',NULL,N'南汇区',NULL, 0,CAST(0x0000A5160141FAC3 AS DateTime),CAST(0x0000A5160141FAC3 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (54, 3,N'奉贤区',N'Fengxian',N'奉贤区',NULL,0,CAST(0x0000A5160141FAC4 AS DateTime),CAST(0x0000A5160141FAC4 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (55,3,N'崇明县',N'Chongming',N'崇明县',NULL,0,CAST(0x0000A5160141FAC4 AS DateTime),CAST(0x0000A5160141FAC4 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (56, 4,N'万州区',N'Wanzhou',N'万州区',NULL,0,CAST(0x0000A5160141FAC4 AS DateTime),CAST(0x0000A5160141FAC4 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (57, 4,N'涪陵区',N'Fuling',N'

涪陵区',NULL,0,CAST(0x0000A5160141FAC4 AS DateTime),CAST(0x0000A5160141FAC4 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (58, 4,N'渝中区',N'Yuzhong',N'渝中区',NULL,0,CAST(0x0000A5160141FAC4 AS DateTime),CAST(0x0000A5160141FAC4 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (59,4,N'大渡口区',N'Dadukou',N'大渡口区',NULL,0,CAST(0x0000A5160141FAC4 AS DateTime),CAST(0x0000A5160141FAC4 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (60, 4,N'江北区',N'Jiangbei',N'江北区',NULL,0,CAST(0x0000A5160141FAC4 AS DateTime),CAST(0x0000A5160141FAC4 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (61, 4,N'沙坪坝区',N'Shapingba', N'沙坪坝区',NULL, 0,CAST(0x0000A5160141FAC4 AS DateTime),CAST(0x0000A5160141FAC4 AS DateTime), NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (62,4,N'九龙坡区',N'Jioulongpo', N'九龙坡区',NULL, 0,CAST(0x0000A5160141FAC4 AS DateTime),CAST(0x0000A5160141FAC4 AS DateTime), NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (63, 4,N'南岸区',N'Nanan',N'南

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (64, 4,N'北碚区',N'Beibei',N'

北碚区',NULL,0,CAST(0x0000A5160141FAC5 AS DateTime),CAST(0x0000A5160141FAC5 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (65, 4,N'万盛区',NULL,N'万盛区',NULL, 0,CAST(0x0000A5160141FAC5 AS DateTime),CAST(0x0000A5160141FAC5 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (66, 4,N'双桥区',NULL,N'双桥区',NULL, 0,CAST(0x0000A5160141FAC5 AS DateTime),CAST(0x0000A5160141FAC5 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (67, 4,N'渝北区',N'Yubei',N'渝北区',NULL, 0,CAST(0x0000A5160141FAC5 AS DateTime),CAST(0x0000A5160141FAC5 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (68, 4,N'巴南区',N'Banan',N'巴南区',NULL, 0,CAST(0x0000A5160141FAC5 AS DateTime),CAST(0x0000A5160141FAC5 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (69,4,N'黔江区',N'Qianjiang',N'黔江区',NULL,0,CAST(0x0000A5160141FAC5 AS DateTime),CAST(0x0000A5160141FAC5 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (70,4,N'长寿区',N'Changshou',N'长寿区',NULL,0,CAST(0x0000A5160141FAC5 AS DateTime),CAST(0x0000A5160141FAC5 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (71, 4,N'江津区',N'Jiangjin',N'江津区',NULL,0,CAST(0x0000A5160141FAC5 AS DateTime),CAST(0x0000A5160141FAC5 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (72, 4,N'合川区',N'Hechuan',N'合川区',NULL,0,CAST(0x0000A5160141FAC5 AS DateTime),CAST(0x0000A5160141FAC5 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (73,4,N'永川区',N'Yongchuan',N'永川区',NULL,0,CAST(0x0000A5160141FAC6 AS DateTime),CAST(0x0000A5160141FAC6 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (74, 4,N'南川区',N'Nanchuan',N'南川区',NULL,0,CAST(0x0000A5160141FAC6 AS DateTime),CAST(0x0000A5160141FAC6 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (75, 4,N'綦江县',N'Qijiang ',N'綦江县',NULL,0,CAST(0x0000A5160141FAC6 AS DateTime),CAST(0x0000A5160141FAC6 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (76, 4,N'潼南县',N'Tongnan',N'潼南县',NULL,0,CAST(0x0000A5160141FAC6 AS DateTime),CAST(0x0000A5160141FAC6 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (77,4,N'铜梁县',N'Tongliang',N'铜梁县',NULL,0,CAST(0x0000A5160141FAC6 AS DateTime),CAST(0x0000A5160141FAC6 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (78, 4,N'大足县',N'Dazu',N'大足县',NULL, 0,CAST(0x0000A5160141FAC6 AS DateTime),CAST(0x0000A5160141FAC6 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (79,4,N'荣昌县',N'Rongchang',N'荣昌县',NULL,0,CAST(0x0000A5160141FAC7 AS DateTime),CAST(0x0000A5160141FAC7 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (80, 4,N'璧山县',N'Bishan',N'

璧山县',NULL,0,CAST(0x0000A5160141FAC7 AS DateTime),CAST(0x0000A5160141FAC7 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (81,4,N'梁平县',N'Liangping',N'梁平县',NULL,0,CAST(0x0000A5160141FAC7 AS DateTime),CAST(0x0000A5160141FAC7 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (82, 4,N'城口县',N'Chengkou',N'城口县',NULL,0,CAST(0x0000A5160141FAC7 AS DateTime),CAST(0x0000A5160141FAC7 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (83, 4,N'丰都县',N'Fengdu',N'

丰都县',NULL,0,CAST(0x0000A5160141FAC7 AS DateTime),CAST(0x0000A5160141FAC7 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (84,4,N'垫江县',N'Dianjiang',N'垫江县',NULL,0,CAST(0x0000A5160141FAC7 AS DateTime),CAST(0x0000A5160141FAC7 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (85, 4,N'武隆县',N'Wulong',N'

武隆县',NULL,0,CAST(0x0000A5160141FAC8 AS DateTime),CAST(0x0000A5160141FAC8 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (86, 4,N'忠县',N'Zhongxian',N'

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (87,4,N'开县',NULL,N'开县',NULL, 0,CAST(0x0000A5160141FAC8 AS DateTime),CAST(0x0000A5160141FAC8 AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (88, 4,N'云阳县',N'Yunyang',N'云阳县',NULL,0,CAST(0x0000A5160141FAC8 AS DateTime),CAST(0x0000A5160141FAC8 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (89, 4,N'奉节县',N'Fengjie',N'奉节县',NULL,0,CAST(0x0000A5160141FAC8 AS DateTime),CAST(0x0000A5160141FAC8 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (90, 4,N'巫山县',N'Wushan',N'

巫山县',NULL,0,CAST(0x0000A5160141FAC8 AS DateTime),CAST(0x0000A5160141FAC8 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (91, 4,N'巫溪县',N'Wuxi',N'巫溪县',NULL, 0,CAST(0x0000A5160141FAC8 AS DateTime),CAST(0x0000A5160141FAC8 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (92,4,N'石柱土家族自治县',N'Shizhu', N'石柱土家族自治县',NULL, 0,CAST(0x0000A5160141FAC8 AS DateTime),CAST(0x0000A5160141FAC8 AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (93, 4,N'秀山土家族苗族自治县',

N'Xiushan',N'秀山土家族苗族自治县',NULL, 0,CAST(0x0000A5160141FAC8 AS DateTime),

CAST(0x0000A5160141FAC8 AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (94, 4,N'酉阳土家族苗族自治县',

N'Youyang',N'酉阳土家族苗族自治县',NULL, 0,CAST(0x0000A5160141FAC8 AS DateTime),

CAST(0x0000A5160141FAC8 AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (95, 4,N'彭水苗族土家族自治县',

N'Pengshui',N'彭水苗族土家族自治县',NULL, 0,CAST(0x0000A5160141FAC9 AS DateTime),

CAST(0x0000A5160141FAC9 AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (96, 5,N'邯山区',NULL,N'邯山区',NULL, 0,CAST(0x0000A5160141FAC9 AS DateTime),CAST(0x0000A5160141FAC9 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (97, 5,N'丛台区',NULL,N'丛台区',NULL, 0,CAST(0x0000A5160141FAC9 AS DateTime),CAST(0x0000A5160141FAC9 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (98, 5,N'复兴区',NULL,N'复兴区',NULL, 0,CAST(0x0000A5160141FAC9 AS DateTime),CAST(0x0000A5160141FAC9 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (99, 5,N'峰峰矿区',NULL,N'峰峰矿区',NULL, 0,CAST(0x0000A5160141FAC9 AS DateTime),CAST(0x0000A5160141FAC9 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (100, 5,N'邯郸县',N'Handan',N'邯郸县',NULL,0,CAST(0x0000A5160141FAC9 AS DateTime),CAST(0x0000A5160141FAC9 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (101, 5,N'临漳县',NULL,N'临漳县',NULL, 0,CAST(0x0000A5160141FAC9 AS DateTime),CAST(0x0000A5160141FAC9 AS DateTime),NULL) GO

print'Processed 100 total records'

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (102, 5,N'成安县',NULL,N'成安县',NULL, 0,CAST(0x0000A5160141FAC9 AS DateTime),CAST(0x0000A5160141FAC9 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (103, 5,N'大名县',NULL,N'大名县',NULL, 0,CAST(0x0000A5160141FACA AS DateTime),CAST(0x0000A5160141FACA AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (104,5,N'涉县',NULL,N'涉县',NULL, 0,CAST(0x0000A5160141FACA AS DateTime),CAST(0x0000A5160141FACA AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (105,5,N'磁县',NULL,N'磁县',NULL, 0,CAST(0x0000A5160141FACA AS DateTime),CAST(0x0000A5160141FACA AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (106, 5,N'肥乡县',NULL,N'肥乡县',NULL, 0,CAST(0x0000A5160141FACA AS DateTime),CAST(0x0000A5160141FACA AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (107, 5,N'永年县',NULL,N'永年县',NULL, 0,CAST(0x0000A5160141FACA AS DateTime),CAST(0x0000A5160141FACA AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode],

0,CAST(0x0000A5160141FACA AS DateTime),CAST(0x0000A5160141FACA AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (109, 5,N'鸡泽县',NULL,N'鸡泽县',NULL, 0,CAST(0x0000A5160141FACA AS DateTime),CAST(0x0000A5160141FACA AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (110, 5,N'广平县',NULL,N'广平县',NULL, 0,CAST(0x0000A5160141FACA AS DateTime),CAST(0x0000A5160141FACA AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (111, 5,N'馆陶县',NULL,N'馆陶县',NULL, 0,CAST(0x0000A5160141FACB AS DateTime),CAST(0x0000A5160141FACB AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (112,5,N'魏县',NULL,N'魏县',NULL, 0,CAST(0x0000A5160141FACB AS DateTime),CAST(0x0000A5160141FACB AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (113, 5,N'曲周县',NULL,N'曲周县',NULL, 0,CAST(0x0000A5160141FACB AS DateTime),CAST(0x0000A5160141FACB AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (114, 5,N'武安市',NULL,N'武安市',NULL, 0,CAST(0x0000A5160141FACB AS DateTime),CAST(0x0000A5160141FACB AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (115, 6,N'长安区',NULL,N'长安区',NULL, 0,CAST(0x0000A5160141FACB AS DateTime),CAST(0x0000A5160141FACB AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (116, 6,N'桥东区',NULL,N'桥东区',NULL, 0,CAST(0x0000A5160141FACB AS DateTime),CAST(0x0000A5160141FACB AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (117, 6,N'桥西区',NULL,N'桥西区',NULL, 0,CAST(0x0000A5160141FACB AS DateTime),CAST(0x0000A5160141FACB AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (118, 6,N'新华区',NULL,N'新华区',NULL, 0,CAST(0x0000A5160141FACB AS DateTime),CAST(0x0000A5160141FACB AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (119, 6,N'井陉矿区',NULL,N'井陉矿区',NULL, 0,CAST(0x0000A5160141FACB AS DateTime),CAST(0x0000A5160141FACB AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (120, 6,N'裕华区',NULL,N'裕华区',NULL, 0,CAST(0x0000A5160141FACC AS DateTime),CAST(0x0000A5160141FACC AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (121, 6,N'井陉县',NULL,N'井陉县',NULL, 0,CAST(0x0000A5160141FACC AS DateTime),CAST(0x0000A5160141FACC AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (122, 6,N'正定县',NULL,N'正定县',NULL, 0,CAST(0x0000A5160141FACC AS DateTime),CAST(0x0000A5160141FACC AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (123, 6,N'栾城县',NULL,N'栾城县',NULL, 0,CAST(0x0000A5160141FACC AS DateTime),CAST(0x0000A5160141FACC AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (124, 6,N'行唐县',NULL,N'行唐县',NULL, 0,CAST(0x0000A5160141FACC AS DateTime),CAST(0x0000A5160141FACC AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (125, 6,N'灵寿县',NULL,N'灵寿县',NULL, 0,CAST(0x0000A5160141FACC AS DateTime),CAST(0x0000A5160141FACC AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (126, 6,N'高邑县',NULL,N'高邑县',NULL, 0,CAST(0x0000A5160141FACC AS DateTime),CAST(0x0000A5160141FACC AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (127, 6,N'深泽县',NULL,N'深泽县',NULL, 0,CAST(0x0000A5160141FACC AS DateTime),CAST(0x0000A5160141FACC AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (128, 6,N'赞皇县',NULL,N'赞皇县',NULL, 0,CAST(0x0000A5160141FACD AS DateTime),CAST(0x0000A5160141FACD AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (129, 6,N'无极县',NULL,N'无极县',NULL, 0,CAST(0x0000A5160141FACD AS DateTime),CAST(0x0000A5160141FACD AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (130, 6,N'平山县',NULL,N'平山县',NULL, 0,CAST(0x0000A5160141FACD AS DateTime),CAST(0x0000A5160141FACD AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (131, 6,N'元氏县',NULL,N'元氏县',NULL, 0,CAST(0x0000A5160141FACE AS DateTime),CAST(0x0000A5160141FACE AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode],

0,CAST(0x0000A5160141FACE AS DateTime),CAST(0x0000A5160141FACE AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (133, 6,N'辛集市',N'Xinji',N'

辛集市',NULL,0,CAST(0x0000A5160141FACE AS DateTime),CAST(0x0000A5160141FACE AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (134, 6,N'藁城市',NULL,N'藁城市',NULL, 0,CAST(0x0000A5160141FACE AS DateTime),CAST(0x0000A5160141FACE AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (135, 6,N'晋州市',NULL,N'晋州市',NULL, 0,CAST(0x0000A5160141FACE AS DateTime),CAST(0x0000A5160141FACE AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (136, 6,N'新乐市',NULL,N'新乐市',NULL, 0,CAST(0x0000A5160141FACE AS DateTime),CAST(0x0000A5160141FACE AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (137, 6,N'鹿泉市',NULL,N'鹿泉市',NULL, 0,CAST(0x0000A5160141FACE AS DateTime),CAST(0x0000A5160141FACE AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (138, 7,N'新市区',NULL,N'新市区',NULL, 0,CAST(0x0000A5160141FACE AS DateTime),CAST(0x0000A5160141FACE AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (139, 7,N'北市区',NULL,N'北市区',NULL, 0,CAST(0x0000A5160141FACF AS DateTime),CAST(0x0000A5160141FACF AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (140, 7,N'南市区',NULL,N'南市区',NULL, 0,CAST(0x0000A5160141FACF AS DateTime),CAST(0x0000A5160141FACF AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (141, 7,N'满城县',NULL,N'满城县',NULL, 0,CAST(0x0000A5160141FACF AS DateTime),CAST(0x0000A5160141FACF AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (142, 7,N'清苑县',NULL,N'清苑县',NULL, 0,CAST(0x0000A5160141FACF AS DateTime),CAST(0x0000A5160141FACF AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (143, 7,N'涞水县',NULL,N'涞水县',NULL, 0,CAST(0x0000A5160141FACF AS DateTime),CAST(0x0000A5160141FACF AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (144, 7,N'阜平县',NULL,N'阜平县',NULL, 0,CAST(0x0000A5160141FACF AS DateTime),CAST(0x0000A5160141FACF AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (145, 7,N'徐水县',NULL,N'徐水县',NULL, 0,CAST(0x0000A5160141FACF AS DateTime),CAST(0x0000A5160141FACF AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (146, 7,N'定兴县',NULL,N'定兴县',NULL, 0,CAST(0x0000A5160141FAD0 AS DateTime),CAST(0x0000A5160141FAD0 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (147,7,N'唐县',NULL,N'唐县',NULL, 0,CAST(0x0000A5160141FAD0 AS DateTime),CAST(0x0000A5160141FAD0 AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (148, 7,N'高阳县',NULL,N'高阳县',NULL, 0,CAST(0x0000A5160141FAD0 AS DateTime),CAST(0x0000A5160141FAD0 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (149, 7,N'容城县',NULL,N'容城县',NULL, 0,CAST(0x0000A5160141FAD0 AS DateTime),CAST(0x0000A5160141FAD0 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (150, 7,N'涞源县',NULL,N'涞源县',NULL, 0,CAST(0x0000A5160141FAD0 AS DateTime),CAST(0x0000A5160141FAD0 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (151, 7,N'望都县',NULL,N'望都县',NULL, 0,CAST(0x0000A5160141FAD0 AS DateTime),CAST(0x0000A5160141FAD0 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (152, 7,N'安新县',NULL,N'安新县',NULL, 0,CAST(0x0000A5160141FAD0 AS DateTime),CAST(0x0000A5160141FAD0 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (153,7,N'易县',NULL,N'易县',NULL, 0,CAST(0x0000A5160141FAD1 AS DateTime),CAST(0x0000A5160141FAD1 AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (154, 7,N'曲阳县',NULL,N'曲阳县',NULL, 0,CAST(0x0000A5160141FAD1 AS DateTime),CAST(0x0000A5160141FAD1 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (155,7,N'蠡县',NULL,N'蠡县',NULL, 0,CAST(0x0000A5160141FAD1 AS DateTime),CAST(0x0000A5160141FAD1 AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode],

',NULL, 0,CAST(0x0000A5160141FAD1 AS DateTime),CAST(0x0000A5160141FAD1 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (157, 7,N'博野县',NULL,N'博野县',NULL, 0,CAST(0x0000A5160141FAD1 AS DateTime),CAST(0x0000A5160141FAD1 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (158,7,N'雄县',NULL,N'雄县',NULL, 0,CAST(0x0000A5160141FAD1 AS DateTime),CAST(0x0000A5160141FAD1 AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (159, 7,N'涿州市',NULL,N'涿州市',NULL, 0,CAST(0x0000A5160141FAD1 AS DateTime),CAST(0x0000A5160141FAD1 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (160,7,N'定州市',N'Dingzhou',N'定州市',NULL,0,CAST(0x0000A5160141FAD1 AS DateTime),CAST(0x0000A5160141FAD1 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (161, 7,N'安国市',NULL,N'安国市',NULL, 0,CAST(0x0000A5160141FAD1 AS DateTime),CAST(0x0000A5160141FAD1 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (162, 7,N'高碑店市',NULL,N'高碑店市',NULL, 0,CAST(0x0000A5160141FAD2 AS DateTime),CAST(0x0000A5160141FAD2 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (163, 8,N'桥东区',NULL,N'桥东区',NULL, 0,CAST(0x0000A5160141FAD2 AS DateTime),CAST(0x0000A5160141FAD2 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (164, 8,N'桥西区',NULL,N'桥西区',NULL, 0,CAST(0x0000A5160141FAD2 AS DateTime),CAST(0x0000A5160141FAD2 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (165, 8,N'宣化区',NULL,N'宣化区',NULL, 0,CAST(0x0000A5160141FAD2 AS DateTime),CAST(0x0000A5160141FAD2 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (166, 8,N'下花园区',NULL,N'下花园区',NULL, 0,CAST(0x0000A5160141FAD2 AS DateTime),CAST(0x0000A5160141FAD2 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (167, 8,N'宣化县',NULL,N'宣化县',NULL, 0,CAST(0x0000A5160141FAD2 AS DateTime),CAST(0x0000A5160141FAD2 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (168, 8,N'张北县',NULL,N'张北县',NULL, 0,CAST(0x0000A5160141FAD2 AS DateTime),CAST(0x0000A5160141FAD2 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (169, 8,N'康保县',NULL,N'康保县',NULL, 0,CAST(0x0000A5160141FAD3 AS DateTime),CAST(0x0000A5160141FAD3 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (170, 8,N'沽源县',NULL,N'沽源县',NULL, 0,CAST(0x0000A5160141FAD3 AS DateTime),CAST(0x0000A5160141FAD3 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (171, 8,N'尚义县',NULL,N'尚义县',NULL, 0,CAST(0x0000A5160141FAD3 AS DateTime),CAST(0x0000A5160141FAD3 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (172,8,N'蔚县',NULL,N'蔚县',NULL, 0,CAST(0x0000A5160141FAD3 AS DateTime),CAST(0x0000A5160141FAD3 AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (173, 8,N'阳原县',NULL,N'阳原县',NULL, 0,CAST(0x0000A5160141FAD3 AS DateTime),CAST(0x0000A5160141FAD3 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (174, 8,N'怀安县',NULL,N'怀安县',NULL, 0,CAST(0x0000A5160141FAD3 AS DateTime),CAST(0x0000A5160141FAD3 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (175, 8,N'万全县',NULL,N'万全县',NULL, 0,CAST(0x0000A5160141FAD3 AS DateTime),CAST(0x0000A5160141FAD3 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (176, 8,N'怀来县',NULL,N'怀来县',NULL, 0,CAST(0x0000A5160141FAD3 AS DateTime),CAST(0x0000A5160141FAD3 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (177, 8,N'涿鹿县',NULL,N'涿鹿县',NULL, 0,CAST(0x0000A5160141FAD4 AS DateTime),CAST(0x0000A5160141FAD4 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (178, 8,N'赤城县',NULL,N'赤城县',NULL, 0,CAST(0x0000A5160141FAD4 AS DateTime),CAST(0x0000A5160141FAD4 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (179, 8,N'崇礼县',NULL,N'崇礼县',NULL, 0,CAST(0x0000A5160141FAD4 AS DateTime),CAST(0x0000A5160141FAD4 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode],

',NULL, 0,CAST(0x0000A5160141FAD4 AS DateTime),CAST(0x0000A5160141FAD4 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (181, 9,N'双滦区',NULL,N'双滦区',NULL, 0,CAST(0x0000A5160141FAD4 AS DateTime),CAST(0x0000A5160141FAD4 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (182, 9,N'鹰手营子矿区',NULL,N'鹰手营子矿区',NULL, 0,CAST(0x0000A5160141FAD4 AS DateTime),CAST(0x0000A5160141FAD4 AS DateTime), NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (183, 9,N'承德县',N'Chengde',N'承德县',NULL,0,CAST(0x0000A5160141FAD4 AS DateTime),CAST(0x0000A5160141FAD4 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (184, 9,N'兴隆县',NULL,N'兴隆县',NULL, 0,CAST(0x0000A5160141FAD4 AS DateTime),CAST(0x0000A5160141FAD4 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (185, 9,N'平泉县',NULL,N'平泉县',NULL, 0,CAST(0x0000A5160141FAD4 AS DateTime),CAST(0x0000A5160141FAD4 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (186, 9,N'滦平县',NULL,N'滦平县',NULL, 0,CAST(0x0000A5160141FAD4 AS DateTime),CAST(0x0000A5160141FAD4 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (187, 9,N'隆化县',NULL,N'隆化县',NULL, 0,CAST(0x0000A5160141FAD4 AS DateTime),CAST(0x0000A5160141FAD4 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (188, 9,N'丰宁满族自治县',NULL,N'丰宁满族自治县',NULL,0,CAST(0x0000A5160141FAD5 AS DateTime),CAST(0x0000A5160141FAD5 AS DateTime), NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (189, 9,N'宽城满族自治县',NULL,N'宽城满族自治县',NULL,0,CAST(0x0000A5160141FAD5 AS DateTime),CAST(0x0000A5160141FAD5 AS DateTime), NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (190,9,N'围场满族蒙古族自治县',NULL, N'围场满族蒙古族自治县',NULL, 0,CAST(0x0000A5160141FAD6 AS DateTime),CAST(0x0000A5160141FAD6 AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (191, 10,N'路南区',NULL,N'路南区',NULL, 0,CAST(0x0000A5160141FAD6 AS DateTime),CAST(0x0000A5160141FAD6 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (192, 10,N'路北区',NULL,N'路北区',NULL, 0,CAST(0x0000A5160141FAD6 AS DateTime),CAST(0x0000A5160141FAD6 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (193, 10,N'古冶区',NULL,N'古冶区',NULL, 0,CAST(0x0000A5160141FAD6 AS DateTime),CAST(0x0000A5160141FAD6 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (194, 10,N'开平区',NULL,N'开平区',NULL, 0,CAST(0x0000A5160141FAD6 AS DateTime),CAST(0x0000A5160141FAD6 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (195, 10,N'丰南区',NULL,N'丰南区',NULL, 0,CAST(0x0000A5160141FAD7 AS DateTime),CAST(0x0000A5160141FAD7 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (196, 10,N'丰润区',NULL,N'丰润区',NULL, 0,CAST(0x0000A5160141FAD7 AS DateTime),CAST(0x0000A5160141FAD7 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (197,10,N'滦县',NULL,N'滦县',NULL, 0,CAST(0x0000A5160141FAD7 AS DateTime),CAST(0x0000A5160141FAD7 AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (198, 10,N'滦南县',NULL,N'滦南县',NULL, 0,CAST(0x0000A5160141FAD7 AS DateTime),CAST(0x0000A5160141FAD7 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (199, 10,N'乐亭县',NULL,N'乐亭县',NULL, 0,CAST(0x0000A5160141FAD7 AS DateTime),CAST(0x0000A5160141FAD7 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (200, 10,N'迁西县',NULL,N'迁西县',NULL, 0,CAST(0x0000A5160141FAD7 AS DateTime),CAST(0x0000A5160141FAD7 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (201, 10,N'玉田县',NULL,N'玉田县',NULL, 0,CAST(0x0000A5160141FAD7 AS DateTime),CAST(0x0000A5160141FAD7 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode],

县',NULL, 0,CAST(0x0000A5160141FAD8 AS DateTime),CAST(0x0000A5160141FAD8 AS DateTime),NULL) GO

print'Processed 200 total records'

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (203, 10,N'遵化市',NULL,N'遵化市',NULL, 0,CAST(0x0000A5160141FAD8 AS DateTime),CAST(0x0000A5160141FAD8 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (204, 10,N'迁安市',NULL,N'迁安市',NULL, 0,CAST(0x0000A5160141FAD8 AS DateTime),CAST(0x0000A5160141FAD8 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (205, 11,N'安次区',NULL,N'安次区',NULL, 0,CAST(0x0000A5160141FAD8 AS DateTime),CAST(0x0000A5160141FAD8 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (206, 11,N'广阳区',NULL,N'广阳区',NULL, 0,CAST(0x0000A5160141FAD8 AS DateTime),CAST(0x0000A5160141FAD8 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (207, 11,N'固安县',NULL,N'固安县',NULL, 0,CAST(0x0000A5160141FAD8 AS DateTime),CAST(0x0000A5160141FAD8 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (208, 11,N'永清县',NULL,N'永清县',NULL, 0,CAST(0x0000A5160141FAD8 AS DateTime),CAST(0x0000A5160141FAD8 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (209, 11,N'香河县',NULL,N'香河县',NULL, 0,CAST(0x0000A5160141FAD9 AS DateTime),CAST(0x0000A5160141FAD9 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (210, 11,N'大城县',NULL,N'大城县',NULL, 0,CAST(0x0000A5160141FAD9 AS DateTime),CAST(0x0000A5160141FAD9 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (211, 11,N'文安县',NULL,N'文安县',NULL, 0,CAST(0x0000A5160141FAD9 AS DateTime),CAST(0x0000A5160141FAD9 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (212,11,N'大厂回族自治县',NULL,N'大厂回族自治县',NULL,0,CAST(0x0000A5160141FAD9 AS DateTime),CAST(0x0000A5160141FAD9 AS DateTime), NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (213, 11,N'霸州市',NULL,N'霸州市',NULL, 0,CAST(0x0000A5160141FAD9 AS DateTime),CAST(0x0000A5160141FAD9 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (214, 11,N'三河市',NULL,N'三河市',NULL, 0,CAST(0x0000A5160141FADA AS DateTime),CAST(0x0000A5160141FADA AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (215, 12,N'新华区',NULL,N'新华区',NULL, 0,CAST(0x0000A5160141FADA AS DateTime),CAST(0x0000A5160141FADA AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (216, 12,N'运河区',NULL,N'运河区',NULL, 0,CAST(0x0000A5160141FADA AS DateTime),CAST(0x0000A5160141FADA AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (217,12,N'沧县',NULL,N'沧县',NULL, 0,CAST(0x0000A5160141FADA AS DateTime),CAST(0x0000A5160141FADA AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (218,12,N'青县',NULL,N'青县',NULL, 0,CAST(0x0000A5160141FADA AS DateTime),CAST(0x0000A5160141FADA AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (219, 12,N'东光县',NULL,N'东光县',NULL, 0,CAST(0x0000A5160141FADA AS DateTime),CAST(0x0000A5160141FADA AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (220, 12,N'海兴县',NULL,N'海兴县',NULL, 0,CAST(0x0000A5160141FADA AS DateTime),CAST(0x0000A5160141FADA AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (221, 12,N'盐山县',NULL,N'盐山县',NULL, 0,CAST(0x0000A5160141FADA AS DateTime),CAST(0x0000A5160141FADA AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (222, 12,N'肃宁县',NULL,N'肃宁县',NULL, 0,CAST(0x0000A5160141FADB AS DateTime),CAST(0x0000A5160141FADB AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (223, 12,N'南皮县',NULL,N'南皮县',NULL, 0,CAST(0x0000A5160141FADB AS DateTime),CAST(0x0000A5160141FADB AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode],

县',NULL, 0,CAST(0x0000A5160141FAE3 AS DateTime),CAST(0x0000A5160141FAE3 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (225,12,N'献县',NULL,N'献县',NULL, 0,CAST(0x0000A5160141FAE3 AS DateTime),CAST(0x0000A5160141FAE3 AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (226,12,N'孟村回族自治县',NULL,N'孟村回族自治县',NULL,0,CAST(0x0000A5160141FAE4 AS DateTime),CAST(0x0000A5160141FAE4 AS DateTime), NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (227, 12,N'泊头市',NULL,N'泊头市',NULL, 0,CAST(0x0000A5160141FAE4 AS DateTime),CAST(0x0000A5160141FAE4 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (228, 12,N'任丘市',NULL,N'任丘市',NULL, 0,CAST(0x0000A5160141FAE4 AS DateTime),CAST(0x0000A5160141FAE4 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (229, 12,N'黄骅市',NULL,N'黄骅市',NULL, 0,CAST(0x0000A5160141FAE5 AS DateTime),CAST(0x0000A5160141FAE5 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (230, 12,N'河间市',NULL,N'河间市',NULL, 0,CAST(0x0000A5160141FAE5 AS DateTime),CAST(0x0000A5160141FAE5 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (231, 13,N'桃城区',NULL,N'桃城区',NULL, 0,CAST(0x0000A5160141FAE5 AS DateTime),CAST(0x0000A5160141FAE5 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (232, 13,N'枣强县',NULL,N'枣强县',NULL, 0,CAST(0x0000A5160141FAE6 AS DateTime),CAST(0x0000A5160141FAE6 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (233, 13,N'武邑县',NULL,N'武邑县',NULL, 0,CAST(0x0000A5160141FAE6 AS DateTime),CAST(0x0000A5160141FAE6 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (234, 13,N'武强县',NULL,N'武强县',NULL, 0,CAST(0x0000A5160141FAE6 AS DateTime),CAST(0x0000A5160141FAE6 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (235, 13,N'饶阳县',NULL,N'饶阳县',NULL, 0,CAST(0x0000A5160141FAE6 AS DateTime),CAST(0x0000A5160141FAE6 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (236, 13,N'安平县',NULL,N'安平县',NULL, 0,CAST(0x0000A5160141FAE7 AS DateTime),CAST(0x0000A5160141FAE7 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (237, 13,N'故城县',NULL,N'故城县',NULL, 0,CAST(0x0000A5160141FAE7 AS DateTime),CAST(0x0000A5160141FAE7 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (238,13,N'景县',NULL,N'景县',NULL, 0,CAST(0x0000A5160141FAE8 AS DateTime),CAST(0x0000A5160141FAE8 AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (239, 13,N'阜城县',NULL,N'阜城县',NULL, 0,CAST(0x0000A5160141FAE8 AS DateTime),CAST(0x0000A5160141FAE8 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (240, 13,N'冀州市',NULL,N'冀州市',NULL, 0,CAST(0x0000A5160141FAE8 AS DateTime),CAST(0x0000A5160141FAE8 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (241, 13,N'深州市',NULL,N'深州市',NULL, 0,CAST(0x0000A5160141FAE9 AS DateTime),CAST(0x0000A5160141FAE9 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (242, 14,N'桥东区',NULL,N'桥东区',NULL, 0,CAST(0x0000A5160141FAE9 AS DateTime),CAST(0x0000A5160141FAE9 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (243, 14,N'桥西区',NULL,N'桥西区',NULL, 0,CAST(0x0000A5160141FAE9 AS DateTime),CAST(0x0000A5160141FAE9 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (244,14,N'邢台县',N'Xingtai',N'邢台县',NULL,0,CAST(0x0000A5160141FAE9 AS DateTime),CAST(0x0000A5160141FAE9 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (245, 14,N'临城县',NULL,N'临城县',NULL, 0,CAST(0x0000A5160141FAEA AS DateTime),CAST(0x0000A5160141FAEA AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (246, 14,N'内丘县',NULL,N'内丘县',NULL, 0,CAST(0x0000A5160141FAEA AS DateTime),CAST(0x0000A5160141FAEA AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (247, 14,N'柏乡县',NULL,N'柏乡县',NULL, 0,CAST(0x0000A5160141FAEB AS DateTime),CAST(0x0000A5160141FAEB AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (248, 14,N'隆尧县',NULL,N'隆尧县',NULL, 0,CAST(0x0000A5160141FAEB AS DateTime),CAST(0x0000A5160141FAEB AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (249,14,N'任县',NULL,N'任县',NULL, 0,CAST(0x0000A5160141FAEB AS DateTime),CAST(0x0000A5160141FAEB AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (250, 14,N'南和县',NULL,N'南和县',NULL, 0,CAST(0x0000A5160141FAEC AS DateTime),CAST(0x0000A5160141FAEC AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (251, 14,N'宁晋县',NULL,N'宁晋县',NULL, 0,CAST(0x0000A5160141FAEC AS DateTime),CAST(0x0000A5160141FAEC AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (252, 14,N'巨鹿县',NULL,N'巨鹿县',NULL, 0,CAST(0x0000A5160141FAEC AS DateTime),CAST(0x0000A5160141FAEC AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (253, 14,N'新河县',NULL,N'新河县',NULL, 0,CAST(0x0000A5160141FAED AS DateTime),CAST(0x0000A5160141FAED AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (254, 14,N'广宗县',NULL,N'广宗县',NULL, 0,CAST(0x0000A5160141FAED AS DateTime),CAST(0x0000A5160141FAED AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (255, 14,N'平乡县',NULL,N'平乡县',NULL, 0,CAST(0x0000A5160141FAED AS DateTime),CAST(0x0000A5160141FAED AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (256,14,N'威县',NULL,N'威县',NULL, 0,CAST(0x0000A5160141FAEE AS DateTime),CAST(0x0000A5160141FAEE AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (257, 14,N'清河县',NULL,N'清河县',NULL, 0,CAST(0x0000A5160141FAEF AS DateTime),CAST(0x0000A5160141FAEF AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (258, 14,N'临西县',NULL,N'临西县',NULL, 0,CAST(0x0000A5160141FAEF AS DateTime),CAST(0x0000A5160141FAEF AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (259, 14,N'南宫市',NULL,N'南宫市',NULL, 0,CAST(0x0000A5160141FAEF AS DateTime),CAST(0x0000A5160141FAEF AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (260, 14,N'沙河市',NULL,N'沙河市',NULL, 0,CAST(0x0000A5160141FAEF AS DateTime),CAST(0x0000A5160141FAEF AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (261, 15,N'海港区',NULL,N'海港区',NULL, 0,CAST(0x0000A5160141FAEF AS DateTime),CAST(0x0000A5160141FAEF AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (262, 15,N'山海关区',NULL,N'山海关区',NULL,0,CAST(0x0000A5160141FAF0 AS DateTime),CAST(0x0000A5160141FAF0 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (263, 15,N'北戴河区',NULL,N'北戴河区',NULL,0,CAST(0x0000A5160141FAF1 AS DateTime),CAST(0x0000A5160141FAF1 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (264,15,N'青龙满族自治县',NULL,N'青龙满族自治县',NULL,0,CAST(0x0000A5160141FAF1 AS DateTime),CAST(0x0000A5160141FAF1 AS DateTime), NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (265, 15,N'昌黎县',NULL,N'昌黎县',NULL, 0,CAST(0x0000A5160141FAF2 AS DateTime),CAST(0x0000A5160141FAF2 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (266, 15,N'抚宁县',NULL,N'抚宁县',NULL, 0,CAST(0x0000A5160141FAF2 AS DateTime),CAST(0x0000A5160141FAF2 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (267, 15,N'卢龙县',NULL,N'卢龙县',NULL, 0,CAST(0x0000A5160141FAF8 AS DateTime),CAST(0x0000A5160141FAF8 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (268, 16,N'朔城区',NULL,N'朔城区',NULL, 0,CAST(0x0000A5160141FAFC AS DateTime),CAST(0x0000A5160141FAFC AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (269, 16,N'平鲁区',NULL,N'平鲁

区',NULL, 0,CAST(0x0000A5160141FAFC AS DateTime),CAST(0x0000A5160141FAFC AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (270, 16,N'山阴县',NULL,N'山阴县',NULL, 0,CAST(0x0000A5160141FAFD AS DateTime),CAST(0x0000A5160141FAFD AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (271,16,N'应县',NULL,N'应县',NULL, 0,CAST(0x0000A5160141FAFD AS DateTime),CAST(0x0000A5160141FAFD AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (272, 16,N'右玉县',NULL,N'右玉县',NULL, 0,CAST(0x0000A5160141FAFD AS DateTime),CAST(0x0000A5160141FAFD AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (273, 16,N'怀仁县',NULL,N'怀仁县',NULL, 0,CAST(0x0000A5160141FAFD AS DateTime),CAST(0x0000A5160141FAFD AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (274, 17,N'忻府区',NULL,N'忻府区',NULL, 0,CAST(0x0000A5160141FAFE AS DateTime),CAST(0x0000A5160141FAFE AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (275, 17,N'定襄县',NULL,N'定襄县',NULL, 0,CAST(0x0000A5160141FAFE AS DateTime),CAST(0x0000A5160141FAFE AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (276, 17,N'五台县',NULL,N'五台县',NULL, 0,CAST(0x0000A5160141FAFE AS DateTime),CAST(0x0000A5160141FAFE AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (277,17,N'代县',NULL,N'代县',NULL, 0,CAST(0x0000A5160141FAFE AS DateTime),CAST(0x0000A5160141FAFE AS DateTime),NULL)

INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (278, 17,N'繁峙县',NULL,N'繁峙县',NULL, 0,CAST(0x0000A5160141FAFF AS DateTime),CAST(0x0000A5160141FAFF AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (279, 17,N'宁武县',NULL,N'宁武县',NULL, 0,CAST(0x0000A5160141FAFF AS DateTime),CAST(0x0000A5160141FAFF AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (280, 17,N'静乐县',NULL,N'静乐县',NULL, 0,CAST(0x0000A5160141FB00 AS DateTime),CAST(0x0000A5160141FB00 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (281, 17,N'神池县',NULL,N'神池县',NULL, 0,CAST(0x0000A5160141FB00 AS DateTime),CAST(0x0000A5160141FB00 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (282, 17,N'五寨县',NULL,N'五寨县',NULL, 0,CAST(0x0000A5160141FB00 AS DateTime),CAST(0x0000A5160141FB00 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (283, 17,N'岢岚县',NULL,N'岢岚县',NULL, 0,CAST(0x0000A5160141FB00 AS DateTime),CAST(0x0000A5160141FB00 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (284, 17,N'河曲县',NULL,N'河曲县',NULL, 0,CAST(0x0000A5160141FB01 AS DateTime),CAST(0x0000A5160141FB01 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (285, 17,N'保德县',NULL,N'保德县',NULL, 0,CAST(0x0000A5160141FB01 AS DateTime),CAST(0x0000A5160141FB01 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (286, 17,N'偏关县',NULL,N'偏关县',NULL, 0,CAST(0x0000A5160141FB01 AS DateTime),CAST(0x0000A5160141FB01 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (287, 17,N'原平市',NULL,N'原平市',NULL, 0,CAST(0x0000A5160141FB01 AS DateTime),CAST(0x0000A5160141FB01 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (288, 18,N'小店区',NULL,N'小店区',NULL, 0,CAST(0x0000A5160141FB01 AS DateTime),CAST(0x0000A5160141FB01 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (289, 18,N'迎泽区',NULL,N'迎泽区',NULL, 0,CAST(0x0000A5160141FB01 AS DateTime),CAST(0x0000A5160141FB01 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (290, 18,N'杏花岭区',NULL,N'杏花岭区',NULL,0,CAST(0x0000A5160141FB01 AS DateTime),CAST(0x0000A5160141FB01 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (291, 18,N'尖草坪区',NULL,N'尖草坪区',NULL,0,CAST(0x0000A5160141FB02 AS DateTime),CAST(0x0000A5160141FB02 AS DateTime),NULL) INSERT[dbo].[Prefectures]([PrefecturesId],[CityId],[ChiName],[EngName],[NameTra],[PostalCode], [IsDel],[LastUpdateTime],[AddTime],[PrefecturesSort])VALUES (292, 18,N'万柏林区',NULL,N'万