时间：2021-07-01 10:21:17 帮助过：4人阅读
IF (EXISTS(SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N‘[dbo].[TB_Province]‘) AND type =‘U‘))
BEGIN
DROP TABLE [dbo].[TB_Province]
END
GO
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TB_Province] (
[ID] bigint IDENTITY(1, 1),
[ProvinceName] nvarchar(50) NULL
) ON [PRIMARY]
GO
IF (EXISTS(SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N‘[dbo].[TB_City]‘) AND type =‘U‘))
BEGIN
DROP TABLE [dbo].[TB_City]
END
GO
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TB_City] (
[ID] bigint IDENTITY(1, 1),
[CityName] nvarchar(50) NULL,
[ZipCode] nvarchar(50) NULL,
[ProvinceID] bigint NULL
) ON [PRIMARY]
GO
IF (EXISTS(SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N‘[dbo].[TB_District]‘) AND type =‘U‘))
BEGIN
DROP TABLE [dbo].[TB_District]
END
GO
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TB_District] (
[ID] bigint IDENTITY(1, 1),
[DistrictName] nvarchar(50) NULL,
[CityID] bigint NULL
) ON [PRIMARY]
GO
SET XACT_ABORT ON
SET IDENTITY_INSERT [dbo].[TB_City] ON
BEGIN TRANSACTION
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (1, N‘北京市‘, N‘100000‘, 1)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (2, N‘天津市‘, N‘100000‘, 2)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (3, N‘石家庄市‘, N‘050000‘, 3)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (4, N‘唐山市‘, N‘063000‘, 3)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (5, N‘秦皇岛市‘, N‘066000‘, 3)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (6, N‘邯郸市‘, N‘056000‘, 3)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (7, N‘邢台市‘, N‘054000‘, 3)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (8, N‘保定市‘, N‘071000‘, 3)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (9, N‘张家口市‘, N‘075000‘, 3)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (10, N‘承德市‘, N‘067000‘, 3)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (11, N‘沧州市‘, N‘061000‘, 3)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (12, N‘廊坊市‘, N‘065000‘, 3)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (13, N‘衡水市‘, N‘053000‘, 3)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (14, N‘太原市‘, N‘030000‘, 4)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (15, N‘大同市‘, N‘037000‘, 4)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (16, N‘阳泉市‘, N‘045000‘, 4)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (17, N‘长治市‘, N‘046000‘, 4)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (18, N‘晋城市‘, N‘048000‘, 4)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (19, N‘朔州市‘, N‘036000‘, 4)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (20, N‘晋中市‘, N‘030600‘, 4)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (21, N‘运城市‘, N‘044000‘, 4)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (22, N‘忻州市‘, N‘034000‘, 4)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (23, N‘临汾市‘, N‘041000‘, 4)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (24, N‘吕梁市‘, N‘030500‘, 4)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (25, N‘呼和浩特市‘, N‘010000‘, 5)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (26, N‘包头市‘, N‘014000‘, 5)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (27, N‘乌海市‘, N‘016000‘, 5)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (28, N‘赤峰市‘, N‘024000‘, 5)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (29, N‘通辽市‘, N‘028000‘, 5)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (30, N‘鄂尔多斯市‘, N‘010300‘, 5)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (31, N‘呼伦贝尔市‘, N‘021000‘, 5)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (32, N‘巴彦淖尔市‘, N‘014400‘, 5)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (33, N‘乌兰察布市‘, N‘011800‘, 5)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (34, N‘兴安盟‘, N‘137500‘, 5)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (35, N‘锡林郭勒盟‘, N‘011100‘, 5)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (36, N‘阿拉善盟‘, N‘016000‘, 5)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (37, N‘沈阳市‘, N‘110000‘, 6)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (38, N‘大连市‘, N‘116000‘, 6)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (39, N‘鞍山市‘, N‘114000‘, 6)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (40, N‘抚顺市‘, N‘113000‘, 6)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (41, N‘本溪市‘, N‘117000‘, 6)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (42, N‘丹东市‘, N‘118000‘, 6)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (43, N‘锦州市‘, N‘121000‘, 6)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (44, N‘营口市‘, N‘115000‘, 6)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (45, N‘阜新市‘, N‘123000‘, 6)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (46, N‘辽阳市‘, N‘111000‘, 6)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (47, N‘盘锦市‘, N‘124000‘, 6)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (48, N‘铁岭市‘, N‘112000‘, 6)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (49, N‘朝阳市‘, N‘122000‘, 6)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (50, N‘葫芦岛市‘, N‘125000‘, 6)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (51, N‘长春市‘, N‘130000‘, 7)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (52, N‘吉林市‘, N‘132000‘, 7)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (53, N‘四平市‘, N‘136000‘, 7)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (54, N‘辽源市‘, N‘136200‘, 7)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (55, N‘通化市‘, N‘134000‘, 7)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (56, N‘白山市‘, N‘134300‘, 7)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (57, N‘松原市‘, N‘131100‘, 7)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (58, N‘白城市‘, N‘137000‘, 7)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (59, N‘延边朝鲜族自治州‘, N‘133000‘, 7)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (60, N‘哈尔滨市‘, N‘150000‘, 8)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (61, N‘齐齐哈尔市‘, N‘161000‘, 8)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (62, N‘鸡西市‘, N‘158100‘, 8)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (63, N‘鹤岗市‘, N‘154100‘, 8)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (64, N‘双鸭山市‘, N‘155100‘, 8)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (65, N‘大庆市‘, N‘163000‘, 8)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (66, N‘伊春市‘, N‘152300‘, 8)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (67, N‘佳木斯市‘, N‘154000‘, 8)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (68, N‘七台河市‘, N‘154600‘, 8)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (69, N‘牡丹江市‘, N‘157000‘, 8)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (70, N‘黑河市‘, N‘164300‘, 8)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (71, N‘绥化市‘, N‘152000‘, 8)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (72, N‘大兴安岭地区‘, N‘165000‘, 8)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (73, N‘上海市‘, N‘200000‘, 9)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (74, N‘南京市‘, N‘210000‘, 10)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (75, N‘无锡市‘, N‘214000‘, 10)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (76, N‘徐州市‘, N‘221000‘, 10)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (77, N‘常州市‘, N‘213000‘, 10)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (78, N‘苏州市‘, N‘215000‘, 10)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (79, N‘南通市‘, N‘226000‘, 10)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (80, N‘连云港市‘, N‘222000‘, 10)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (81, N‘淮安市‘, N‘223200‘, 10)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (82, N‘盐城市‘, N‘224000‘, 10)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (83, N‘扬州市‘, N‘225000‘, 10)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (84, N‘镇江市‘, N‘212000‘, 10)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (85, N‘泰州市‘, N‘225300‘, 10)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (86, N‘宿迁市‘, N‘223800‘, 10)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (87, N‘杭州市‘, N‘310000‘, 11)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (88, N‘宁波市‘, N‘315000‘, 11)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (89, N‘温州市‘, N‘325000‘, 11)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (90, N‘嘉兴市‘, N‘314000‘, 11)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (91, N‘湖州市‘, N‘313000‘, 11)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (92, N‘绍兴市‘, N‘312000‘, 11)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (93, N‘金华市‘, N‘321000‘, 11)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (94, N‘衢州市‘, N‘324000‘, 11)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (95, N‘舟山市‘, N‘316000‘, 11)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (96, N‘台州市‘, N‘318000‘, 11)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (97, N‘丽水市‘, N‘323000‘, 11)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (98, N‘合肥市‘, N‘230000‘, 12)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (99, N‘芜湖市‘, N‘241000‘, 12)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (100, N‘蚌埠市‘, N‘233000‘, 12)
COMMIT TRANSACTION
GO
BEGIN TRANSACTION
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (101, N‘淮南市‘, N‘232000‘, 12)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (102, N‘马鞍山市‘, N‘243000‘, 12)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (103, N‘淮北市‘, N‘235000‘, 12)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (104, N‘铜陵市‘, N‘244000‘, 12)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (105, N‘安庆市‘, N‘246000‘, 12)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (106, N‘黄山市‘, N‘242700‘, 12)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (107, N‘滁州市‘, N‘239000‘, 12)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (108, N‘阜阳市‘, N‘236100‘, 12)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (109, N‘宿州市‘, N‘234100‘, 12)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (111, N‘六安市‘, N‘237000‘, 12)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (112, N‘亳州市‘, N‘236800‘, 12)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (113, N‘池州市‘, N‘247100‘, 12)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (114, N‘宣城市‘, N‘366000‘, 12)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (115, N‘福州市‘, N‘350000‘, 13)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (116, N‘厦门市‘, N‘361000‘, 13)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (117, N‘莆田市‘, N‘351100‘, 13)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (118, N‘三明市‘, N‘365000‘, 13)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (119, N‘泉州市‘, N‘362000‘, 13)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (120, N‘漳州市‘, N‘363000‘, 13)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (121, N‘南平市‘, N‘353000‘, 13)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (122, N‘龙岩市‘, N‘364000‘, 13)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (123, N‘宁德市‘, N‘352100‘, 13)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (124, N‘南昌市‘, N‘330000‘, 14)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (125, N‘景德镇市‘, N‘333000‘, 14)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (126, N‘萍乡市‘, N‘337000‘, 14)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (127, N‘九江市‘, N‘332000‘, 14)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (128, N‘新余市‘, N‘338000‘, 14)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (129, N‘鹰潭市‘, N‘335000‘, 14)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (130, N‘赣州市‘, N‘341000‘, 14)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (131, N‘吉安市‘, N‘343000‘, 14)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (132, N‘宜春市‘, N‘336000‘, 14)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (133, N‘抚州市‘, N‘332900‘, 14)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (134, N‘上饶市‘, N‘334000‘, 14)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (135, N‘济南市‘, N‘250000‘, 15)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (136, N‘青岛市‘, N‘266000‘, 15)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (137, N‘淄博市‘, N‘255000‘, 15)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (138, N‘枣庄市‘, N‘277100‘, 15)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (139, N‘东营市‘, N‘257000‘, 15)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (140, N‘烟台市‘, N‘264000‘, 15)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (141, N‘潍坊市‘, N‘261000‘, 15)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (142, N‘济宁市‘, N‘272100‘, 15)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (143, N‘泰安市‘, N‘271000‘, 15)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (144, N‘威海市‘, N‘265700‘, 15)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (145, N‘日照市‘, N‘276800‘, 15)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (146, N‘莱芜市‘, N‘271100‘, 15)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (147, N‘临沂市‘, N‘276000‘, 15)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (148, N‘德州市‘, N‘253000‘, 15)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (149, N‘聊城市‘, N‘252000‘, 15)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (150, N‘滨州市‘, N‘256600‘, 15)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (151, N‘荷泽市‘, N‘255000‘, 15)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (152, N‘郑州市‘, N‘450000‘, 16)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (153, N‘开封市‘, N‘475000‘, 16)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (154, N‘洛阳市‘, N‘471000‘, 16)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (155, N‘平顶山市‘, N‘467000‘, 16)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (156, N‘安阳市‘, N‘454900‘, 16)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (157, N‘鹤壁市‘, N‘456600‘, 16)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (158, N‘新乡市‘, N‘453000‘, 16)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (159, N‘焦作市‘, N‘454100‘, 16)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (160, N‘濮阳市‘, N‘457000‘, 16)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (161, N‘许昌市‘, N‘461000‘, 16)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (162, N‘漯河市‘, N‘462000‘, 16)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (163, N‘三门峡市‘, N‘472000‘, 16)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (164, N‘南阳市‘, N‘473000‘, 16)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (165, N‘商丘市‘, N‘476000‘, 16)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (166, N‘信阳市‘, N‘464000‘, 16)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (167, N‘周口市‘, N‘466000‘, 16)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (168, N‘驻马店市‘, N‘463000‘, 16)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (169, N‘武汉市‘, N‘430000‘, 17)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (170, N‘黄石市‘, N‘435000‘, 17)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (171, N‘十堰市‘, N‘442000‘, 17)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (172, N‘宜昌市‘, N‘443000‘, 17)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (173, N‘襄阳市‘, N‘441000‘, 17)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (174, N‘鄂州市‘, N‘436000‘, 17)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (175, N‘荆门市‘, N‘448000‘, 17)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (176, N‘孝感市‘, N‘432100‘, 17)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (177, N‘荆州市‘, N‘434000‘, 17)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (178, N‘黄冈市‘, N‘438000‘, 17)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (179, N‘咸宁市‘, N‘437000‘, 17)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (180, N‘随州市‘, N‘441300‘, 17)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (181, N‘恩施土家族苗族自治州‘, N‘445000‘, 17)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (182, N‘神农架‘, N‘442400‘, 17)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (183, N‘长沙市‘, N‘410000‘, 18)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (184, N‘株洲市‘, N‘412000‘, 18)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (185, N‘湘潭市‘, N‘411100‘, 18)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (186, N‘衡阳市‘, N‘421000‘, 18)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (187, N‘邵阳市‘, N‘422000‘, 18)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (188, N‘岳阳市‘, N‘414000‘, 18)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (189, N‘常德市‘, N‘415000‘, 18)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (190, N‘张家界市‘, N‘427000‘, 18)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (191, N‘益阳市‘, N‘413000‘, 18)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (192, N‘郴州市‘, N‘423000‘, 18)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (193, N‘永州市‘, N‘425000‘, 18)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (194, N‘怀化市‘, N‘418000‘, 18)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (195, N‘娄底市‘, N‘417000‘, 18)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (196, N‘湘西土家族苗族自治州‘, N‘416000‘, 18)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (197, N‘广州市‘, N‘510000‘, 19)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (198, N‘韶关市‘, N‘521000‘, 19)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (199, N‘深圳市‘, N‘518000‘, 19)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (200, N‘珠海市‘, N‘519000‘, 19)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (201, N‘汕头市‘, N‘515000‘, 19)
COMMIT TRANSACTION
GO
BEGIN TRANSACTION
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (202, N‘佛山市‘, N‘528000‘, 19)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (203, N‘江门市‘, N‘529000‘, 19)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (204, N‘湛江市‘, N‘524000‘, 19)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (205, N‘茂名市‘, N‘525000‘, 19)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (206, N‘肇庆市‘, N‘526000‘, 19)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (207, N‘惠州市‘, N‘516000‘, 19)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (208, N‘梅州市‘, N‘514000‘, 19)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (209, N‘汕尾市‘, N‘516600‘, 19)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (210, N‘河源市‘, N‘517000‘, 19)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (211, N‘阳江市‘, N‘529500‘, 19)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (212, N‘清远市‘, N‘511500‘, 19)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (213, N‘东莞市‘, N‘511700‘, 19)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (214, N‘中山市‘, N‘528400‘, 19)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (215, N‘潮州市‘, N‘515600‘, 19)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (216, N‘揭阳市‘, N‘522000‘, 19)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (217, N‘云浮市‘, N‘527300‘, 19)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (218, N‘南宁市‘, N‘530000‘, 20)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (219, N‘柳州市‘, N‘545000‘, 20)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (220, N‘桂林市‘, N‘541000‘, 20)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (221, N‘梧州市‘, N‘543000‘, 20)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (222, N‘北海市‘, N‘536000‘, 20)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (223, N‘防城港市‘, N‘538000‘, 20)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (224, N‘钦州市‘, N‘535000‘, 20)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (225, N‘贵港市‘, N‘537100‘, 20)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (226, N‘玉林市‘, N‘537000‘, 20)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (227, N‘百色市‘, N‘533000‘, 20)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (228, N‘贺州市‘, N‘542800‘, 20)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (229, N‘河池市‘, N‘547000‘, 20)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (230, N‘来宾市‘, N‘546100‘, 20)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (231, N‘崇左市‘, N‘532200‘, 20)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (232, N‘海口市‘, N‘570000‘, 21)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (233, N‘三沙市‘, N‘572000‘, 21)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (234, N‘重庆市‘, N‘400000‘, 22)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (235, N‘成都市‘, N‘610000‘, 23)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (236, N‘自贡市‘, N‘643000‘, 23)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (237, N‘攀枝花市‘, N‘617000‘, 23)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (238, N‘泸州市‘, N‘646100‘, 23)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (239, N‘德阳市‘, N‘618000‘, 23)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (240, N‘绵阳市‘, N‘621000‘, 23)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (241, N‘广元市‘, N‘628000‘, 23)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (242, N‘遂宁市‘, N‘629000‘, 23)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (243, N‘内江市‘, N‘641000‘, 23)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (244, N‘乐山市‘, N‘614000‘, 23)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (245, N‘南充市‘, N‘637000‘, 23)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (246, N‘眉山市‘, N‘612100‘, 23)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (247, N‘宜宾市‘, N‘644000‘, 23)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (248, N‘广安市‘, N‘638000‘, 23)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (249, N‘达州市‘, N‘635000‘, 23)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (250, N‘雅安市‘, N‘625000‘, 23)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (251, N‘巴中市‘, N‘635500‘, 23)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (252, N‘资阳市‘, N‘641300‘, 23)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (253, N‘阿坝藏族羌族自治州‘, N‘624600‘, 23)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (254, N‘甘孜藏族自治州‘, N‘626000‘, 23)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (255, N‘凉山彝族自治州‘, N‘615000‘, 23)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (256, N‘贵阳市‘, N‘55000‘, 24)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (257, N‘六盘水市‘, N‘553000‘, 24)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (258, N‘遵义市‘, N‘563000‘, 24)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (259, N‘安顺市‘, N‘561000‘, 24)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (260, N‘铜仁市‘, N‘554300‘, 24)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (261, N‘黔西南布依族苗族自治州‘, N‘551500‘, 24)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (262, N‘毕节市‘, N‘551700‘, 24)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (263, N‘黔东南苗族侗族自治州‘, N‘551500‘, 24)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (264, N‘黔南布依族苗族自治州‘, N‘550100‘, 24)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (265, N‘昆明市‘, N‘650000‘, 25)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (266, N‘曲靖市‘, N‘655000‘, 25)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (267, N‘玉溪市‘, N‘653100‘, 25)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (268, N‘保山市‘, N‘678000‘, 25)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (269, N‘昭通市‘, N‘657000‘, 25)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (270, N‘丽江市‘, N‘674100‘, 25)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (271, N‘普洱市‘, N‘665000‘, 25)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (272, N‘临沧市‘, N‘677000‘, 25)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (273, N‘楚雄彝族自治州‘, N‘675000‘, 25)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (274, N‘红河哈尼族彝族自治州‘, N‘654400‘, 25)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (275, N‘文山壮族苗族自治州‘, N‘663000‘, 25)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (276, N‘西双版纳傣族自治州‘, N‘666200‘, 25)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (277, N‘大理白族自治州‘, N‘671000‘, 25)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (278, N‘德宏傣族景颇族自治州‘, N‘678400‘, 25)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (279, N‘怒江傈僳族自治州‘, N‘671400‘, 25)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (280, N‘迪庆藏族自治州‘, N‘674400‘, 25)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (281, N‘拉萨市‘, N‘850000‘, 26)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (282, N‘昌都地区‘, N‘854000‘, 26)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (283, N‘山南地区‘, N‘856000‘, 26)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (284, N‘日喀则地区‘, N‘857000‘, 26)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (285, N‘那曲地区‘, N‘852000‘, 26)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (286, N‘阿里地区‘, N‘859100‘, 26)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (287, N‘林芝地区‘, N‘860100‘, 26)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (288, N‘西安市‘, N‘710000‘, 27)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (289, N‘铜川市‘, N‘727000‘, 27)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (290, N‘宝鸡市‘, N‘721000‘, 27)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (291, N‘咸阳市‘, N‘712000‘, 27)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (292, N‘渭南市‘, N‘714000‘, 27)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (293, N‘延安市‘, N‘716000‘, 27)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (294, N‘汉中市‘, N‘723000‘, 27)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (295, N‘榆林市‘, N‘719000‘, 27)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (296, N‘安康市‘, N‘725000‘, 27)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (297, N‘商洛市‘, N‘711500‘, 27)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (298, N‘兰州市‘, N‘730000‘, 28)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (300, N‘嘉峪关市‘, N‘737100‘, 28)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (301, N‘白银市‘, N‘730900‘, 28)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (302, N‘天水市‘, N‘741000‘, 28)
COMMIT TRANSACTION
GO
BEGIN TRANSACTION
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (303, N‘武威市‘, N‘733000‘, 28)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (304, N‘张掖市‘, N‘734000‘, 28)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (305, N‘平凉市‘, N‘744000‘, 28)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (306, N‘酒泉市‘, N‘735000‘, 28)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (307, N‘庆阳市‘, N‘744500‘, 28)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (308, N‘定西市‘, N‘743000‘, 28)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (309, N‘陇南市‘, N‘742100‘, 28)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (310, N‘临夏回族自治州‘, N‘731100‘, 28)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (311, N‘甘南藏族自治州‘, N‘747000‘, 28)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (312, N‘西宁市‘, N‘810000‘, 29)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (313, N‘海东地区‘, N‘810600‘, 29)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (314, N‘海北藏族自治州‘, N‘810300‘, 29)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (315, N‘黄南藏族自治州‘, N‘811300‘, 29)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (316, N‘海南藏族自治州‘, N‘813000‘, 29)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (317, N‘果洛藏族自治州‘, N‘814000‘, 29)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (318, N‘玉树藏族自治州‘, N‘815000‘, 29)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (319, N‘海西蒙古族藏族自治州‘, N‘817000‘, 29)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (320, N‘银川市‘, N‘750000‘, 30)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (321, N‘石嘴山市‘, N‘753000‘, 30)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (322, N‘吴忠市‘, N‘751100‘, 30)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (323, N‘固原市‘, N‘756000‘, 30)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (324, N‘中卫市‘, N‘751700‘, 30)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (325, N‘乌鲁木齐市‘, N‘830000‘, 31)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (326, N‘克拉玛依市‘, N‘834000‘, 31)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (327, N‘吐鲁番地区‘, N‘838000‘, 31)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (328, N‘哈密地区‘, N‘839000‘, 31)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (329, N‘昌吉回族自治州‘, N‘831100‘, 31)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (330, N‘博尔塔拉蒙古自治州‘, N‘833400‘, 31)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (331, N‘巴音郭楞蒙古自治州‘, N‘841000‘, 31)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (332, N‘阿克苏地区‘, N‘843000‘, 31)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (333, N‘克孜勒苏柯尔克孜自治州‘, N‘835600‘, 31)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (334, N‘喀什地区‘, N‘844000‘, 31)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (335, N‘和田地区‘, N‘848000‘, 31)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (336, N‘伊犁哈萨克自治州‘, N‘833200‘, 31)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (337, N‘塔城地区‘, N‘834700‘, 31)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (338, N‘阿勒泰地区‘, N‘836500‘, 31)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (339, N‘石河子市‘, N‘832000‘, 31)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (340, N‘阿拉尔市‘, N‘843300‘, 31)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (341, N‘图木舒克市‘, N‘843900‘, 31)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (342, N‘五家渠市‘, N‘831300‘, 31)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (343, N‘香港特别行政区‘, N‘000000‘, 32)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (344, N‘澳门特别行政区‘, N‘000000‘, 33)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (345, N‘台湾省‘, N‘000000‘, 34)
INSERT INTO [dbo].[TB_City] ([ID], [CityName], [ZipCode], [ProvinceID])
VALUES (346, N‘三亚市‘, NULL, 21)
SET IDENTITY_INSERT [dbo].[TB_City] OFF
SET IDENTITY_INSERT [dbo].[TB_District] ON
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (1, N‘东城区‘, 1)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (2, N‘西城区‘, 1)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (5, N‘朝阳区‘, 1)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (6, N‘丰台区‘, 1)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (7, N‘石景山区‘, 1)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (8, N‘海淀区‘, 1)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (9, N‘门头沟区‘, 1)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (10, N‘房山区‘, 1)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (11, N‘通州区‘, 1)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (12, N‘顺义区‘, 1)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (13, N‘昌平区‘, 1)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (14, N‘大兴区‘, 1)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (15, N‘怀柔区‘, 1)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (16, N‘平谷区‘, 1)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (17, N‘密云县‘, 1)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (18, N‘延庆县‘, 1)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (19, N‘和平区‘, 2)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (20, N‘河东区‘, 2)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (21, N‘河西区‘, 2)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (22, N‘南开区‘, 2)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (23, N‘河北区‘, 2)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (24, N‘红桥区‘, 2)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (28, N‘东丽区‘, 2)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (29, N‘西青区‘, 2)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (30, N‘津南区‘, 2)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (31, N‘北辰区‘, 2)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (32, N‘武清区‘, 2)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (33, N‘宝坻区‘, 2)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (34, N‘宁河县‘, 2)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (35, N‘静海县‘, 2)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (36, N‘蓟县‘, 2)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (37, N‘长安区‘, 3)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (38, N‘桥东区‘, 3)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (39, N‘桥西区‘, 3)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (40, N‘新华区‘, 3)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (41, N‘井陉矿区‘, 3)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (42, N‘裕华区‘, 3)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (43, N‘井陉县‘, 3)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (44, N‘正定县‘, 3)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (45, N‘栾城县‘, 3)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (46, N‘行唐县‘, 3)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (47, N‘灵寿县‘, 3)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (48, N‘高邑县‘, 3)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (49, N‘深泽县‘, 3)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (50, N‘赞皇县‘, 3)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (51, N‘无极县‘, 3)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (52, N‘平山县‘, 3)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (53, N‘元氏县‘, 3)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (54, N‘赵县‘, 3)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (55, N‘辛集市‘, 3)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (56, N‘藁城市‘, 3)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (57, N‘晋州市‘, 3)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (58, N‘新乐市‘, 3)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (59, N‘鹿泉市‘, 3)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (60, N‘路南区‘, 4)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (61, N‘路北区‘, 4)
COMMIT TRANSACTION
GO
BEGIN TRANSACTION
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (62, N‘古冶区‘, 4)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (63, N‘开平区‘, 4)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (64, N‘丰南区‘, 4)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (65, N‘丰润区‘, 4)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (66, N‘滦县‘, 4)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (67, N‘滦南县‘, 4)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (68, N‘乐亭县‘, 4)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (69, N‘迁西县‘, 4)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (70, N‘玉田县‘, 4)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (72, N‘遵化市‘, 4)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (73, N‘迁安市‘, 4)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (74, N‘海港区‘, 5)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (75, N‘山海关区‘, 5)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (76, N‘北戴河区‘, 5)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (77, N‘青龙满族自治县‘, 5)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (78, N‘昌黎县‘, 5)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (79, N‘抚宁县‘, 5)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (80, N‘卢龙县‘, 5)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (81, N‘邯山区‘, 6)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (82, N‘丛台区‘, 6)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (83, N‘复兴区‘, 6)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (84, N‘峰峰矿区‘, 6)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (85, N‘邯郸县‘, 6)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (86, N‘临漳县‘, 6)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (87, N‘成安县‘, 6)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (88, N‘大名县‘, 6)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (89, N‘涉县‘, 6)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (90, N‘磁县‘, 6)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (91, N‘肥乡县‘, 6)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (92, N‘永年县‘, 6)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (93, N‘邱县‘, 6)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (94, N‘鸡泽县‘, 6)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (95, N‘广平县‘, 6)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (96, N‘馆陶县‘, 6)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (97, N‘魏县‘, 6)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (98, N‘曲周县‘, 6)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (99, N‘武安市‘, 6)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (100, N‘桥东区‘, 7)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (101, N‘桥西区‘, 7)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (102, N‘邢台县‘, 7)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (103, N‘临城县‘, 7)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (104, N‘内丘县‘, 7)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (105, N‘柏乡县‘, 7)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (106, N‘隆尧县‘, 7)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (107, N‘任县‘, 7)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (108, N‘南和县‘, 7)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (109, N‘宁晋县‘, 7)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (110, N‘巨鹿县‘, 7)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (111, N‘新河县‘, 7)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (112, N‘广宗县‘, 7)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (113, N‘平乡县‘, 7)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (114, N‘威县‘, 7)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (115, N‘清河县‘, 7)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (116, N‘临西县‘, 7)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (117, N‘南宫市‘, 7)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (118, N‘沙河市‘, 7)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (119, N‘新市区‘, 8)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (120, N‘北市区‘, 8)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (121, N‘南市区‘, 8)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (122, N‘满城县‘, 8)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (123, N‘清苑县‘, 8)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (124, N‘涞水县‘, 8)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (125, N‘阜平县‘, 8)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (126, N‘徐水县‘, 8)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (127, N‘定兴县‘, 8)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (128, N‘唐县‘, 8)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (129, N‘高阳县‘, 8)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (130, N‘容城县‘, 8)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (131, N‘涞源县‘, 8)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (132, N‘望都县‘, 8)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (133, N‘安新县‘, 8)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (134, N‘易县‘, 8)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (135, N‘曲阳县‘, 8)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (136, N‘蠡县‘, 8)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (137, N‘顺平县‘, 8)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (138, N‘博野县‘, 8)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (139, N‘雄县‘, 8)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (140, N‘涿州市‘, 8)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (141, N‘定州市‘, 8)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (142, N‘安国市‘, 8)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (143, N‘高碑店市‘, 8)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (144, N‘桥东区‘, 9)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (145, N‘桥西区‘, 9)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (146, N‘宣化区‘, 9)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (147, N‘下花园区‘, 9)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (148, N‘宣化县‘, 9)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (149, N‘张北县‘, 9)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (150, N‘康保县‘, 9)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (151, N‘沽源县‘, 9)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (152, N‘尚义县‘, 9)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (153, N‘蔚县‘, 9)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (154, N‘阳原县‘, 9)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (155, N‘怀安县‘, 9)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (156, N‘万全县‘, 9)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (157, N‘怀来县‘, 9)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (158, N‘涿鹿县‘, 9)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (159, N‘赤城县‘, 9)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (160, N‘崇礼县‘, 9)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (161, N‘双桥区‘, 10)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (162, N‘双滦区‘, 10)
COMMIT TRANSACTION
GO
BEGIN TRANSACTION
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (163, N‘鹰手营子矿区‘, 10)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (164, N‘承德县‘, 10)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (165, N‘兴隆县‘, 10)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (166, N‘平泉县‘, 10)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (167, N‘滦平县‘, 10)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (168, N‘隆化县‘, 10)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (169, N‘丰宁满族自治县‘, 10)
INSERT INTO [dbo].[TB_District] ([ID], [DistrictName], [CityID])
VALUES (170, N‘宽城满族自治县‘, 10)
INSERT INTO [dbo].[