SET IDENTITY_INSERT [dbo].[Area] ON
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (1, 1, N'东城区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (2, 1, N'西城区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (3, 1, N'崇文区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (4, 1, N'宣武区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (5, 1, N'朝阳区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (6, 1, N'丰台区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (7, 1, N'石景山区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (8, 1, N'海淀区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (9, 1, N'门头沟区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (10, 1, N'房山区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (11, 1, N'通州区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (12, 1, N'顺义区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (13, 1, N'昌平区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (14, 1, N'大兴区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (15, 1, N'怀柔区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (16, 1, N'平谷区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (17, 1, N'密云县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (18, 1, N'延庆县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (19, 2, N'和平区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (20, 2, N'河东区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (21, 2, N'河西区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (22, 2, N'南开区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (23, 2, N'河北区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (24, 2, N'红桥区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (25, 2, N'塘沽区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (26, 2, N'汉沽区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (27, 2, N'大港区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (28, 2, N'东丽区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (29, 2, N'西青区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (30, 2, N'津南区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (31, 2, N'北辰区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (32, 2, N'武清区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (33, 2, N'宝坻区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (34, 2, N'宁河县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (35, 2, N'静海县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (36, 2, N'蓟县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (37, 3, N'长安区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (38, 3, N'桥东区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (39, 3, N'桥西区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (40, 3, N'新华区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (41, 3, N'井陉矿区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (42, 3, N'裕华区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (43, 3, N'井陉县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (44, 3, N'正定县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (45, 3, N'栾城县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (46, 3, N'行唐县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (47, 3, N'灵寿县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (48, 3, N'高邑县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (49, 3, N'深泽县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (50, 3, N'赞皇县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (51, 3, N'无极县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (52, 3, N'平山县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (53, 3, N'元氏县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (54, 3, N'赵县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (55, 3, N'辛集市', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (56, 3, N'藁城市', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (57, 3, N'晋州市', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (58, 3, N'新乐市', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (59, 3, N'鹿泉市', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (60, 4, N'路南区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (61, 4, N'路北区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (62, 4, N'古冶区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (63, 4, N'开平区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (64, 4, N'丰南区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (65, 4, N'丰润区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (66, 4, N'滦县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (67, 4, N'滦南县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (68, 4, N'乐亭县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (69, 4, N'迁西县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (70, 4, N'玉田县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (71, 4, N'唐海县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (72, 4, N'遵化市', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (73, 4, N'迁安市', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (74, 5, N'海港区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (75, 5, N'山海关区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (76, 5, N'北戴河区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (77, 5, N'青龙县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (78, 5, N'昌黎县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (79, 5, N'抚宁县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (80, 5, N'卢龙县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (81, 6, N'邯山区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (82, 6, N'丛台区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (83, 6, N'复兴区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (84, 6, N'峰峰矿区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (85, 6, N'邯郸县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (86, 6, N'临漳县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (87, 6, N'成安县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (88, 6, N'大名县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (89, 6, N'涉县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (90, 6, N'磁县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (91, 6, N'肥乡县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (92, 6, N'永年县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (93, 6, N'邱县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (94, 6, N'鸡泽县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (95, 6, N
省市区三级联动的数据来源——sql insert语句
4星 · 超过85%的资源 需积分: 10 174 浏览量
2017-11-06
15:16:46
上传
评论
收藏 29KB ZIP 举报
依依丫头
- 粉丝: 6
- 资源: 13
最新资源
- 1040g0cg310ravpiu6ibg5pg00tsipsln3ju2d0g 2
- 基于Python的SAR图像去噪CNN-NLM设计源码
- redhat6升级到redhat7,过程redhat6.x-> redhat6.10->rehat7.9 主版本最高版本
- 基于Django的流程引擎设计源码
- 基于Node.js的Express框架与MySQL的后台管理系统设计源码
- 基于Java的Flink流批一体数据处理快速集成开发框架设计源码
- FirstFilterOrderCompare
- Screenshot_2024-03-28-19-17-25-020_com.ss.android.lark.jpg
- 基于Java的车辆违章信息查询系统设计源码
- wqeAFSDADWDAESD
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈