以前项目中曾经做过类似省、市、区无刷新联动的功能。当时用的是AjaxPro2.dll实现的功能,也曾经用jquery实现了类似的功能。现在趁有空自己用javascript结合XmlHttp做了同样的功能。具体代码如下:
1.html代码
2、cs代码
3、数据库
4、数据库数据
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (1,1,N'北京市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (2,1,N'天津市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (3,1,N'河北省','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (4,1,N'山西省','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (5,1,N'内蒙古','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (6,1,N'辽宁省','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (7,1,N'吉林省','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (8,1,N'黑龙江','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (9,1,N'上海市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (10,1,N'江苏省','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (11,1,N'浙江省','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (12,1,N'安徽省','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (13,1,N'福建省','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (14,1,N'江西省','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (15,1,N'山东省','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (16,1,N'河南省','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (17,1,N'湖北省','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (18,1,N'湖南省','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (19,1,N'广东省','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (20,1,N'广 西','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (21,1,N'海南省','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (22,1,N'重庆市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (23,1,N'四川省','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (24,1,N'贵州省','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (25,1,N'云南省','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (26,1,N'西 藏','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (27,1,N'陕西省','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (28,1,N'甘肃省','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (29,1,N'青海省','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (30,1,N'宁 夏','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (31,1,N'新 疆','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (32,1,N'台湾省','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (33,1,N'香 港','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_province] ([ProvinceId],[CountryId],[ProvinceName],[CreateTime],[UpdateTime],[Flag]) values (34,1,N'澳 门','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
----------------------------------------------------------------------------------------------------------------------------------------------------
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (1,1,1,N'北京市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (2,1,2,N'天津市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (3,1,3,N'石家庄市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (4,1,3,N'唐山市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (5,1,3,N'秦皇岛市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (6,1,3,N'邯郸市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (7,1,3,N'邢台市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (8,1,3,N'保定市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (9,1,3,N'张家口市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (10,1,3,N'承德市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (11,1,3,N'沧州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (12,1,3,N'廊坊市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (13,1,3,N'衡水市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (14,1,4,N'太原市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (15,1,4,N'大同市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (16,1,4,N'阳泉市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (17,1,4,N'长治市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (18,1,4,N'晋城市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (19,1,4,N'朔州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (20,1,4,N'晋中市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (21,1,4,N'运城市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (22,1,4,N'忻州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (23,1,4,N'临汾市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (24,1,4,N'吕梁市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (25,1,5,N'呼和浩特市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (26,1,5,N'包头市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (27,1,5,N'乌海市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (28,1,5,N'赤峰市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (29,1,5,N'通辽市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (30,1,5,N'鄂尔多斯市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (31,1,5,N'呼伦贝尔市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (32,1,5,N'巴彦淖尔市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (33,1,5,N'乌兰察布市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (34,1,5,N'兴安盟','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (35,1,5,N'锡林郭勒盟','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (36,1,5,N'阿拉善盟','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (37,1,6,N'沈阳市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (38,1,6,N'大连市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (39,1,6,N'鞍山市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (40,1,6,N'抚顺市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (41,1,6,N'本溪市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (42,1,6,N'丹东市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (43,1,6,N'锦州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (44,1,6,N'营口市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (45,1,6,N'阜新市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (46,1,6,N'辽阳市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (47,1,6,N'盘锦市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (48,1,6,N'铁岭市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (49,1,6,N'朝阳市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (50,1,6,N'葫芦岛市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (51,1,7,N'长春市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (52,1,7,N'吉林市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (53,1,7,N'四平市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (54,1,7,N'辽源市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (55,1,7,N'通化市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (56,1,7,N'白山市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (57,1,7,N'松原市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (58,1,7,N'白城市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (59,1,7,N'延边朝鲜族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (60,1,8,N'哈尔滨市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (61,1,8,N'齐齐哈尔市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (62,1,8,N'鸡西市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (63,1,8,N'鹤岗市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (64,1,8,N'双鸭山市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (65,1,8,N'大庆市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (66,1,8,N'伊春市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (67,1,8,N'佳木斯市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (68,1,8,N'七台河市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (69,1,8,N'牡丹江市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (70,1,8,N'黑河市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (71,1,8,N'绥化市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (72,1,8,N'大兴安岭地区','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (73,1,9,N'上海市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (74,1,9,N'县','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (75,1,10,N'南京市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (76,1,10,N'无锡市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (77,1,10,N'徐州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (78,1,10,N'常州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (79,1,10,N'苏州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (80,1,10,N'南通市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (81,1,10,N'连云港市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (82,1,10,N'淮安市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (83,1,10,N'盐城市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (84,1,10,N'扬州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (85,1,10,N'镇江市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (86,1,10,N'泰州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (87,1,10,N'宿迁市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (88,1,11,N'杭州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (89,1,11,N'宁波市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (90,1,11,N'温州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (91,1,11,N'嘉兴市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (92,1,11,N'湖州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (93,1,11,N'绍兴市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (94,1,11,N'金华市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (95,1,11,N'衢州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (96,1,11,N'舟山市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (97,1,11,N'台州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (98,1,11,N'丽水市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (99,1,12,N'合肥市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (100,1,12,N'芜湖市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (101,1,12,N'蚌埠市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (102,1,12,N'淮南市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (103,1,12,N'马鞍山市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (104,1,12,N'淮北市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (105,1,12,N'铜陵市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (106,1,12,N'安庆市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (107,1,12,N'黄山市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (108,1,12,N'滁州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (109,1,12,N'阜阳市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (110,1,12,N'宿州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (111,1,12,N'巢湖市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (112,1,12,N'六安市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (113,1,12,N'亳州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (114,1,12,N'池州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (115,1,12,N'宣城市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (116,1,13,N'福州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (117,1,13,N'厦门市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (118,1,13,N'莆田市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (119,1,13,N'三明市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (120,1,13,N'泉州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (121,1,13,N'漳州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (122,1,13,N'南平市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (123,1,13,N'龙岩市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (124,1,13,N'宁德市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (125,1,14,N'南昌市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (126,1,14,N'景德镇市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (127,1,14,N'萍乡市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (128,1,14,N'九江市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (129,1,14,N'新余市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (130,1,14,N'鹰潭市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (131,1,14,N'赣州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (132,1,14,N'吉安市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (133,1,14,N'宜春市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (134,1,14,N'抚州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (135,1,14,N'上饶市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (136,1,15,N'济南市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (137,1,15,N'青岛市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (138,1,15,N'淄博市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (139,1,15,N'枣庄市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (140,1,15,N'东营市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (141,1,15,N'烟台市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (142,1,15,N'潍坊市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (143,1,15,N'济宁市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (144,1,15,N'泰安市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (145,1,15,N'威海市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (146,1,15,N'日照市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (147,1,15,N'莱芜市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (148,1,15,N'临沂市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (149,1,15,N'德州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (150,1,15,N'聊城市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (151,1,15,N'滨州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (152,1,15,N'荷泽市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (153,1,16,N'郑州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (154,1,16,N'开封市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (155,1,16,N'洛阳市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (156,1,16,N'平顶山市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (157,1,16,N'安阳市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (158,1,16,N'鹤壁市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (159,1,16,N'新乡市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (160,1,16,N'焦作市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (161,1,16,N'濮阳市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (162,1,16,N'许昌市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (163,1,16,N'漯河市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (164,1,16,N'三门峡市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (165,1,16,N'南阳市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (166,1,16,N'商丘市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (167,1,16,N'信阳市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (168,1,16,N'周口市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (169,1,16,N'驻马店市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (170,1,17,N'武汉市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (171,1,17,N'黄石市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (172,1,17,N'十堰市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (173,1,17,N'宜昌市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (174,1,17,N'襄樊市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (175,1,17,N'鄂州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (176,1,17,N'荆门市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (177,1,17,N'孝感市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (178,1,17,N'荆州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (179,1,17,N'黄冈市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (180,1,17,N'咸宁市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (181,1,17,N'随州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (182,1,17,N'恩施土家族苗族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (183,1,17,N'省直辖行政单位','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (184,1,18,N'长沙市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (185,1,18,N'株洲市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (186,1,18,N'湘潭市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (187,1,18,N'衡阳市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (188,1,18,N'邵阳市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (189,1,18,N'岳阳市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (190,1,18,N'常德市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (191,1,18,N'张家界市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (192,1,18,N'益阳市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (193,1,18,N'郴州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (194,1,18,N'永州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (195,1,18,N'怀化市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (196,1,18,N'娄底市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (197,1,18,N'湘西土家族苗族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (198,1,19,N'广州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (199,1,19,N'韶关市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (200,1,19,N'深圳市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (201,1,19,N'珠海市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (202,1,19,N'汕头市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (203,1,19,N'佛山市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (204,1,19,N'江门市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (205,1,19,N'湛江市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (206,1,19,N'茂名市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (207,1,19,N'肇庆市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (208,1,19,N'惠州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (209,1,19,N'梅州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (210,1,19,N'汕尾市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (211,1,19,N'河源市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (212,1,19,N'阳江市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (213,1,19,N'清远市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (214,1,19,N'东莞市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (215,1,19,N'中山市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (216,1,19,N'潮州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (217,1,19,N'揭阳市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (218,1,19,N'云浮市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (219,1,20,N'南宁市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (220,1,20,N'柳州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (221,1,20,N'桂林市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (222,1,20,N'梧州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (223,1,20,N'北海市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (224,1,20,N'防城港市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (225,1,20,N'钦州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (226,1,20,N'贵港市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (227,1,20,N'玉林市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (228,1,20,N'百色市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (229,1,20,N'贺州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (230,1,20,N'河池市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (231,1,20,N'来宾市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (232,1,20,N'崇左市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (233,1,21,N'海口市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (234,1,21,N'三亚市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (235,1,21,N'省直辖县级行政单位','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (236,1,22,N'重庆市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (237,1,22,N'县','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (238,1,22,N'市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (239,1,23,N'成都市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (240,1,23,N'自贡市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (241,1,23,N'攀枝花市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (242,1,23,N'泸州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (243,1,23,N'德阳市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (244,1,23,N'绵阳市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (245,1,23,N'广元市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (246,1,23,N'遂宁市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (247,1,23,N'内江市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (248,1,23,N'乐山市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (249,1,23,N'南充市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (250,1,23,N'眉山市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (251,1,23,N'宜宾市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (252,1,23,N'广安市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (253,1,23,N'达州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (254,1,23,N'雅安市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (255,1,23,N'巴中市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (256,1,23,N'资阳市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (257,1,23,N'阿坝藏族羌族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (258,1,23,N'甘孜藏族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (259,1,23,N'凉山彝族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (260,1,24,N'贵阳市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (261,1,24,N'六盘水市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (262,1,24,N'遵义市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (263,1,24,N'安顺市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (264,1,24,N'铜仁地区','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (265,1,24,N'黔西南布依族苗族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (266,1,24,N'毕节地区','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (267,1,24,N'黔东南苗族侗族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (268,1,24,N'黔南布依族苗族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (269,1,25,N'昆明市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (270,1,25,N'曲靖市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (271,1,25,N'玉溪市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (272,1,25,N'保山市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (273,1,25,N'昭通市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (274,1,25,N'丽江市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (275,1,25,N'思茅市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (276,1,25,N'临沧市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (277,1,25,N'楚雄彝族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (278,1,25,N'红河哈尼族彝族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (279,1,25,N'文山壮族苗族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (280,1,25,N'西双版纳傣族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (281,1,25,N'大理白族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (282,1,25,N'德宏傣族景颇族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (283,1,25,N'怒江傈僳族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (284,1,25,N'迪庆藏族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (285,1,26,N'拉萨市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (286,1,26,N'昌都地区','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (287,1,26,N'山南地区','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (288,1,26,N'日喀则地区','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (289,1,26,N'那曲地区','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (290,1,26,N'阿里地区','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (291,1,26,N'林芝地区','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (292,1,27,N'西安市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (293,1,27,N'铜川市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (294,1,27,N'宝鸡市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (295,1,27,N'咸阳市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (296,1,27,N'渭南市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (297,1,27,N'延安市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (298,1,27,N'汉中市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (299,1,27,N'榆林市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (300,1,27,N'安康市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (301,1,27,N'商洛市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (302,1,28,N'兰州市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (303,1,28,N'嘉峪关市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (304,1,28,N'金昌市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (305,1,28,N'白银市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (306,1,28,N'天水市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (307,1,28,N'武威市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (308,1,28,N'张掖市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (309,1,28,N'平凉市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (310,1,28,N'酒泉市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (311,1,28,N'庆阳市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (312,1,28,N'定西市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (313,1,28,N'陇南市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (314,1,28,N'临夏回族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (315,1,28,N'甘南藏族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (316,1,29,N'西宁市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (317,1,29,N'海东地区','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (318,1,29,N'海北藏族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (319,1,29,N'黄南藏族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (320,1,29,N'海南藏族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (321,1,29,N'果洛藏族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (322,1,29,N'玉树藏族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (323,1,29,N'海西蒙古族藏族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (324,1,30,N'银川市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (325,1,30,N'石嘴山市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (326,1,30,N'吴忠市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (327,1,30,N'固原市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (328,1,30,N'中卫市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (329,1,31,N'乌鲁木齐市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (330,1,31,N'克拉玛依市','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (331,1,31,N'吐鲁番地区','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (332,1,31,N'哈密地区','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (333,1,31,N'昌吉回族自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (334,1,31,N'博尔塔拉蒙古自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (335,1,31,N'巴音郭楞蒙古自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (336,1,31,N'阿克苏地区','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (337,1,31,N'克孜勒苏柯尔克孜自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (338,1,31,N'喀什地区','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (339,1,31,N'和田地区','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (340,1,31,N'伊犁哈萨克自治州','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (341,1,31,N'塔城地区','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (342,1,31,N'阿勒泰地区','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (343,1,31,N'省直辖行政单位','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (344,1,32,N'台湾','11 1 2010 9:35AM','11 1 2010 9:35AM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (345,1,33,N'香港','11 1 2010 9:35AM','11 1 2010 9:35AM',0)
INSERT INTO [core_city] ([CityId],[CountryId],[ProvinceId],[CityName],[CreateTime],[UpdateTime],[Flag]) values (346,1,34,N'澳门','11 1 2010 9:35AM','11 1 2010 9:35AM',0)
----------------------------------------------------------------------------------------------------------------------------------------------------
由于区县的数据太多,这里只添加少量数据作为示例:
INSERT INTO [core_District] ([DistrictId],[CountryId],[ProvinceId],[CityId],[DistrictName],[Postcode],[CreateTime],[UpdateTime],[Flag]) values (1,1,1,1,N'东城区','110101','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_District] ([DistrictId],[CountryId],[ProvinceId],[CityId],[DistrictName],[Postcode],[CreateTime],[UpdateTime],[Flag]) values (2,1,1,1,N'西城区','110102','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_District] ([DistrictId],[CountryId],[ProvinceId],[CityId],[DistrictName],[Postcode],[CreateTime],[UpdateTime],[Flag]) values (3,1,1,1,N'崇文区','110103','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_District] ([DistrictId],[CountryId],[ProvinceId],[CityId],[DistrictName],[Postcode],[CreateTime],[UpdateTime],[Flag]) values (4,1,1,1,N'宣武区','110104','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_District] ([DistrictId],[CountryId],[ProvinceId],[CityId],[DistrictName],[Postcode],[CreateTime],[UpdateTime],[Flag]) values (5,1,1,1,N'朝阳区','110105','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_District] ([DistrictId],[CountryId],[ProvinceId],[CityId],[DistrictName],[Postcode],[CreateTime],[UpdateTime],[Flag]) values (6,1,1,1,N'丰台区','110106','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_District] ([DistrictId],[CountryId],[ProvinceId],[CityId],[DistrictName],[Postcode],[CreateTime],[UpdateTime],[Flag]) values (7,1,1,1,N'石景山区','110107','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_District] ([DistrictId],[CountryId],[ProvinceId],[CityId],[DistrictName],[Postcode],[CreateTime],[UpdateTime],[Flag]) values (8,1,1,1,N'海淀区','110108','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_District] ([DistrictId],[CountryId],[ProvinceId],[CityId],[DistrictName],[Postcode],[CreateTime],[UpdateTime],[Flag]) values (9,1,1,1,N'门头沟区','110109','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_District] ([DistrictId],[CountryId],[ProvinceId],[CityId],[DistrictName],[Postcode],[CreateTime],[UpdateTime],[Flag]) values (10,1,1,1,N'房山区','110111','08 5 2010 12:48PM','08 5 2010 12:48PM',0)
INSERT INTO [core_District] ([DistrictId],[CountryId],[ProvinceId],[CityId],[DistrictName],[Postcode],[CreateTime],[UpdateTime],[Flag]) values (11,1,1,1,N'通州区','110112','08 5 2010 12:48PM','08 5 2010 12:48PM',0)