CSDN论坛 > MS-SQL Server > 基础类

请问高手怎样在触发器中返回insert into t_tab02(name) values('" + @no + "')的执行结果! [问题点数:0分]

Bbs1
本版专家分:0
结帖率 97.35%
CSDN今日推荐
Bbs6
本版专家分:8235
Blank
红花 2001年8月 其他数据库开发大版内专家分月排行榜第一
2001年7月 其他数据库开发大版内专家分月排行榜第一
2001年7月 MS-SQL Server大版内专家分月排行榜第一
2001年6月 MS-SQL Server大版内专家分月排行榜第一
Blank
黄花 2001年8月 MS-SQL Server大版内专家分月排行榜第二
Blank
蓝花 2001年2月 MS-SQL Server大版内专家分月排行榜第三
Bbs2
本版专家分:107
Bbs1
本版专家分:10
匿名用户不能发表回复!
其他相关推荐
Andorid中操作数据库的insert的两种方法以及nullColumnHack
一、发现问题 先看两种方法插入数据 代码片段,双击复制 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 public void save(Person p)   {    SQLiteDatabase db = dbHelper.getWritableDat
INSERT小记(insert into select和not in,values括号里不能放select)
记一次初学愚蠢经历,如果未来发现更好的方法,也算留念
数据库基本操作(创建表和添加触发器)
简述: 复习一下数据库基本操作创建表和触发器 1. 创建一张表 注意: 一个表只能有一个PRIMARY KEY 例如下面我加了两个primary key create table table1( id1 int primary key, id2 int primary key, name varchar(8) );就会出现,下面错误,因为只能有一个主键primary key
【触发器】数据库_触发器实例
数据库触发器案例 一、课堂演示案例 例一:创建一个简单的insert触发器 先创建一个数据库备用 create database sampledb go   use sampledb go   在新创建的库中创建一个表备用 create table aa (  a int,  b int ) go   在新创建的表上创建一个insert触发器 use samp
Struts2_Hibernate3_Freemak
Framework: struts2 & hibernate3.0 & freemak & mysql create table Student( id int identity primary key, sex varchar(10), name varchar(50), address varchar(30); score float(10) ); insert into Student(sex,name,address,score) values('1','haojie','深圳罗湖',1.3); insert into Student(sex,name,address,score) values('0','tim','福田',2.3); insert into Student(sex,name,address,score) values('1','aaa','南山',3.3); insert into Student(sex,name,address,score) values('0','bbb','深圳',4.3); insert into Student(sex,name,address,score) values('1','ccc','罗湖',5.3); insert into Student(sex,name,address,score) values('0','ddd','盐田',6.3); insert into Student(sex,name,address,score) values('1','eee','宝安',7.3);
中国各省市区代码名称(三级)Sql脚本
中国各省市区代码名称(三级)excel文档,共有3441条数据。已有上下级父子关系,可以直接导入数据库使用。 部分代码如下: CREATE TABLE [dbo].[tb_City]( [RecNo] [int] NOT NULL, [Code] [varchar](50) NULL, [Name] [nvarchar](50) NULL, [ParentNo] [int] NULL, CONSTRAINT [PK_tb_City] PRIMARY KEY CLUSTERED ( [RecNo] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (1, N'110000', N'北京市', 0) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (2, N'110101', N'东城区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (3, N'110102', N'西城区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (4, N'110105', N'朝阳区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (5, N'110106', N'丰台区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (6, N'110107', N'石景山区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (7, N'110108', N'海淀区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (8, N'110109', N'门头沟区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (9, N'110111', N'房山区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (10, N'110112', N'通州区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (11, N'110113', N'顺义区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (12, N'110114', N'昌平区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (13, N'110115', N'大兴区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (14, N'110116', N'怀柔区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (15, N'110117', N'平谷区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (16, N'110118', N'密云区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (17, N'110119', N'延庆区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (18, N'120000', N'天津市', 0) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (19, N'120101', N'和平区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (20, N'120102', N'河东区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (21, N'120103', N'河西区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (22, N'120104', N'南开区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (23, N'120105', N'河北区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (24, N'120106', N'红桥区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (25, N'120110', N'东丽区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (26, N'120111', N'西青区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (27, N'120112', N'津南区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (28, N'120113', N'北辰区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (29, N'120114', N'武清区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (30, N'120115', N'宝坻区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (31, N'120116', N'滨海新区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (32, N'120117', N'宁河区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (33, N'120118', N'静海区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (34, N'120119', N'蓟州区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (35, N'130000', N'河北省', 0) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (36, N'130100', N'石家庄市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (37, N'130102', N'长安区', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (38, N'130104', N'桥西区', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (39, N'130105', N'新华区', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (40, N'130107', N'井陉矿区', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (41, N'130108', N'裕华区', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (42, N'130109', N'藁城区', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (43, N'130110', N'鹿泉区', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (44, N'130111', N'栾城区', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (45, N'130121', N'井陉县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (46, N'130123', N'正定县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (47, N'130125', N'行唐县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (48, N'130126', N'灵寿县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (49, N'130127', N'高邑县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (50, N'130128', N'深泽县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (51, N'130129', N'赞皇县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (52, N'130130', N'无极县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (53, N'130131', N'平山县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (54, N'130132', N'元氏县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (55, N'130133', N'赵县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (56, N'130181', N'辛集市', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (57, N'130183', N'晋州市', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (58, N'130184', N'新乐市', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (59, N'130200', N'唐山市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (60, N'130202', N'路南区', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (61, N'130203', N'路北区', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (62, N'130204', N'古冶区', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (63, N'130205', N'开平区', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (64, N'130207', N'丰南区', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (65, N'130208', N'丰润区', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (66, N'130209', N'曹妃甸区', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (67, N'130223', N'滦县', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (68, N'130224', N'滦南县', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (69, N'130225', N'乐亭县', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (70, N'130227', N'迁西县', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (71, N'130229', N'玉田县', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (72, N'130281', N'遵化市', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (73, N'130283', N'迁安市', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (74, N'130300', N'秦皇岛市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (75, N'130302', N'海港区', 74) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (76, N'130303', N'山海关区', 74) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (77, N'130304', N'北戴河区', 74) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (78, N'130306', N'抚宁区', 74) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (79, N'130321', N'青龙满族自治县', 74) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (80, N'130322', N'昌黎县', 74) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (81, N'130324', N'卢龙县', 74) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (82, N'130400', N'邯郸市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (83, N'130402', N'邯山区', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (84, N'130403', N'丛台区', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (85, N'130404', N'复兴区', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (86, N'130406', N'峰峰矿区', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (87, N'130407', N'肥乡区', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (88, N'130408', N'永年区', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (89, N'130423', N'临漳县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (90, N'130424', N'成安县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (91, N'130425', N'大名县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (92, N'130426', N'涉县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (93, N'130427', N'磁县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (94, N'130430', N'邱县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (95, N'130431', N'鸡泽县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (96, N'130432', N'广平县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (97, N'130433', N'馆陶县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (98, N'130434', N'魏县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (99, N'130435', N'曲周县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (100, N'130481', N'武安市', 82) GO INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (101, N'130500', N'邢台市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (102, N'130502', N'桥东区', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (103, N'130503', N'桥西区', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (104, N'130521', N'邢台县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (105, N'130522', N'临城县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (106, N'130523', N'内丘县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (107, N'130524', N'柏乡县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (108, N'130525', N'隆尧县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (109, N'130526', N'任县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (110, N'130527', N'南和县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (111, N'130528', N'宁晋县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (112, N'130529', N'巨鹿县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (113, N'130530', N'新河县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (114, N'130531', N'广宗县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (115, N'130532', N'平乡县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (116, N'130533', N'威县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (117, N'130534', N'清河县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (118, N'130535', N'临西县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (119, N'130581', N'南宫市', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (120, N'130582', N'沙河市', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (121, N'130600', N'保定市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (122, N'130602', N'竞秀区', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (123, N'130606', N'莲池区', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (124, N'130607', N'满城区', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (125, N'130608', N'清苑区', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (126, N'130609', N'徐水区', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (127, N'130623', N'涞水县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (128, N'130624', N'阜平县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (129, N'130626', N'定兴县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (130, N'130627', N'唐县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (131, N'130628', N'高阳县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (132, N'130629', N'容城县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (133, N'130630', N'涞源县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (134, N'130631', N'望都县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (135, N'130632', N'安新县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (136, N'130633', N'易县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (137, N'130634', N'曲阳县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (138, N'130635', N'蠡县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (139, N'130636', N'顺平县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (140, N'130637', N'博野县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (141, N'130638', N'雄县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (142, N'130681', N'涿州市', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (143, N'130682', N'定州市', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (144, N'130683', N'安国市', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (145, N'130684', N'高碑店市', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (146, N'130700', N'张家口市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (147, N'130702', N'桥东区', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (148, N'130703', N'桥西区', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (149, N'130705', N'宣化区', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (150, N'130706', N'下花园区', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (151, N'130708', N'万全区', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (152, N'130709', N'崇礼区', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (153, N'130722', N'张北县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (154, N'130723', N'康保县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (155, N'130724', N'沽源县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (156, N'130725', N'尚义县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (157, N'130726', N'蔚县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (158, N'130727', N'阳原县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (159, N'130728', N'怀安县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (160, N'130730', N'怀来县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (161, N'130731', N'涿鹿县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (162, N'130732', N'赤城县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (163, N'130800', N'承德市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (164, N'130802', N'双桥区', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (165, N'130803', N'双滦区', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (166, N'130804', N'鹰手营子矿区', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (167, N'130821', N'承德县', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (168, N'130822', N'兴隆县', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (169, N'130824', N'滦平县', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (170, N'130825', N'隆化县', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (171, N'130826', N'丰宁满族自治县', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (172, N'130827', N'宽城满族自治县', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (173, N'130828', N'围场满族蒙古族自治县', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (174, N'130881', N'平泉市', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (175, N'130900', N'沧州市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (176, N'130902', N'新华区', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (177, N'130903', N'运河区', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (178, N'130921', N'沧县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (179, N'130922', N'青县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (180, N'130923', N'东光县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (181, N'130924', N'海兴县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (182, N'130925', N'盐山县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (183, N'130926', N'肃宁县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (184, N'130927', N'南皮县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (185, N'130928', N'吴桥县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (186, N'130929', N'献县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (187, N'130930', N'孟村回族自治县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (188, N'130981', N'泊头市', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (189, N'130982', N'任丘市', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (190, N'130983', N'黄骅市', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (191, N'130984', N'河间市', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (192, N'131000', N'廊坊市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (193, N'131002', N'安次区', 192) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (194, N'131003', N'广阳区', 192) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (195, N'131022', N'固安县', 192) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (196, N'131023', N'永清县', 192) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (197, N'131024', N'香河县', 192) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (198, N'131025', N'大城县', 192) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (199, N'131026', N'文安县', 192) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (200, N'131028', N'大厂回族自治县', 192) GO INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (201, N'131081', N'霸州市', 192) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (202, N'131082', N'三河市', 192) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (203, N'131100', N'衡水市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (204, N'131102', N'桃城区', 203) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (205, N'131103', N'冀州区', 203) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (206, N'131121', N'枣强县', 203) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (207, N'131122', N'武邑县', 203) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (208, N'131123', N'武强县', 203) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (209, N'131124', N'饶阳县', 203) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (210, N'131125', N'安平县', 203) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (211, N'131126', N'故城县', 203) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (212, N'131127', N'景县', 203) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (213, N'131128', N'阜城县', 203) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (214, N'131182', N'深州市', 203) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (215, N'140000', N'山西省', 0) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (216, N'140100', N'太原市', 215) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (217, N'140105', N'小店区', 216) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (218, N'140106', N'迎泽区', 216) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (219, N'140107', N'杏花岭区', 216) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (220, N'140108', N'尖草坪区', 216) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (221, N'140109', N'万柏林区', 216) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (222, N'140110', N'晋源区', 216) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (223, N'140121', N'清徐县', 216) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (224, N'140122', N'阳曲县', 216) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (225, N'140123', N'娄烦县', 216) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (226, N'140181', N'古交市', 216) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (227, N'140200', N'大同市', 215) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (228, N'140202', N'城区', 227) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (229, N'140203', N'矿区', 227) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (230, N'140211', N'南郊区', 227) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (231, N'140212', N'新荣区', 227) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (232, N'140221', N'阳高县', 227) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (233, N'140222', N'天镇县', 227) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (234, N'140223', N'广灵县', 227) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (235, N'140224', N'灵丘县', 227) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (236, N'140225', N'浑源县', 227) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (237, N'140226', N'左云县', 227) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (238, N'140227', N'大同县', 227) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (239, N'140300', N'阳泉市', 215) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (240, N'140302', N'城区', 239) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (241, N'140303', N'矿区', 239) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (242, N'140311', N'郊区', 239) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (243, N'140321', N'平定县', 239) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (244, N'140322', N'盂县', 239) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (245, N'140400', N'长治市', 215) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (246, N'140402', N'城区', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (247, N'140411', N'郊区', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (248, N'140421', N'长治县', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (249, N'140423', N'襄垣县', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (250, N'140424', N'屯留县', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (251, N'140425', N'平顺县', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (252, N'140426', N'黎城县', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (253, N'140427', N'壶关县', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (254, N'140428', N'长子县', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (255, N'140429', N'武乡县', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (256, N'140430', N'沁县', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (257, N'140431', N'沁源县', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (258, N'140481', N'潞城市', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (259, N'140500', N'晋城市', 215) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (260, N'140502', N'城区', 259) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (261, N'140521', N'沁水县', 259) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (262, N'140522', N'阳城县', 259) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (263, N'140524', N'陵川县', 259) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (264, N'140525', N'泽州县', 259) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (265, N'140581', N'高平市', 259) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (266, N'140600', N'朔州市', 215) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (267, N'140602', N'朔城区', 266) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (268, N'140603', N'平鲁区', 266) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (269, N'140621', N'山阴县', 266) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (270, N'140622', N'应县', 266) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (271, N'140623', N'右玉县', 266) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (272, N'140624', N'怀仁县', 266) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (273, N'140700', N'晋中市', 215) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (274, N'140702', N'榆次区', 273) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (275, N'140721', N'榆社县', 273) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (276, N'140722', N'左权县', 273) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (277, N'140723', N'和顺县', 273) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (278, N'140724', N'昔阳县', 273) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (279, N'140725', N'寿阳县', 273) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (280, N'140726', N'太谷县', 273) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (281, N'140727', N'祁县', 273) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (282, N'140728', N'平遥县', 273) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (283, N'140729', N'灵石县', 273) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (284, N'140781', N'介休市', 273) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (285, N'140800', N'运城市', 215) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (286, N'140802', N'盐湖区', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (287, N'140821', N'临猗县', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (288, N'140822', N'万荣县', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (289, N'140823', N'闻喜县', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (290, N'140824', N'稷山县', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (291, N'140825', N'新绛县', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (292, N'140826', N'绛县', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (293, N'140827', N'垣曲县', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (294, N'140828', N'夏县', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (295, N'140829', N'平陆县', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (296, N'140830', N'芮城县', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (297, N'140881', N'永济市', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (298, N'140882', N'河津市', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (299, N'140900', N'忻州市', 215) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (300, N'140902', N'忻府区', 299) GO INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (301, N'140921', N'定襄县', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (302, N'140922', N'五台县', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (303, N'140923', N'代县', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (304, N'140924', N'繁峙县', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (305, N'140925', N'宁武县', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (306, N'140926', N'静乐县', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (307, N'140927', N'神池县', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (308, N'140928', N'五寨县', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (309, N'140929', N'岢岚县', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (310, N'140930', N'河曲县', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (311, N'140931', N'保德县', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (312, N'140932', N'偏关县', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (313, N'140981', N'原平市', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (314, N'141000', N'临汾市', 215) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (315, N'141002', N'尧都区', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (316, N'141021', N'曲沃县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (317, N'141022', N'翼城县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (318, N'141023', N'襄汾县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (319, N'141024', N'洪洞县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (320, N'141025', N'古县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (321, N'141026', N'安泽县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (322, N'141027', N'浮山县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (323, N'141028', N'吉县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (324, N'141029', N'乡宁县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (325, N'141030', N'大宁县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (326, N'141031', N'隰县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (327, N'141032', N'永和县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (328, N'141033', N'蒲县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (329, N'141034', N'汾西县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (330, N'141081', N'侯马市', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (331, N'141082', N'霍州市', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (332, N'141100', N'吕梁市', 215) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (333, N'141102', N'离石区', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (334, N'141121', N'文水县', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (335, N'141122', N'交城县', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (336, N'141123', N'兴县', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (337, N'141124', N'临县', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (338, N'141125', N'柳林县', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (339, N'141126', N'石楼县', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (340, N'141127', N'岚县', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (341, N'141128', N'方山县', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (342, N'141129', N'中阳县', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (343, N'141130', N'交口县', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (344, N'141181', N'孝义市', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (345, N'141182', N'汾阳市', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (346, N'150000', N'内蒙古自治区', 0) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (347, N'150100', N'呼和浩特市', 346) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (348, N'150102', N'新城区', 347) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (349, N'150103', N'回民区', 347) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (350, N'150104', N'玉泉区', 347) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (351, N'150105', N'赛罕区', 347) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (352, N'150121', N'土默特左旗', 347) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (353, N'150122', N'托克托县', 347) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (354, N'150123', N'和林格尔县', 347) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (355, N'150124', N'清水河县', 347) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (356, N'150125', N'武川县', 347) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (357, N'150200', N'包头市', 346) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (358, N'150202', N'东河区', 357) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (359, N'150203', N'昆都仑区', 357) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (360, N'150204', N'青山区', 357) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (361, N'150205', N'石拐区', 357) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (362, N'150206', N'白云鄂博矿区', 357) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (363, N'150207', N'九原区', 357) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (364, N'150221', N'土默特右旗', 357) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (365, N'150222', N'固阳县', 357) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (366, N'150223', N'达尔罕茂明安联合旗', 357) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (367, N'150300', N'乌海市', 346) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (368, N'150302', N'海勃湾区', 367) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (369, N'150303', N'海南区', 367) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (370, N'150304', N'乌达区', 367) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (371, N'150400', N'赤峰市', 346) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (372, N'150402', N'红山区', 371) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (373, N'150403', N'元宝山区', 371) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (374, N'150404', N'松山区', 371) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (375, N'150421', N'阿鲁科尔沁旗', 371) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (376, N'150422', N'巴林左旗', 371) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (377, N'150423', N'巴林右旗', 371) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (378, N'150424', N'林西县', 371) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (379, N'150425', N'克什克腾旗', 371) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (380, N'150426', N'翁牛特旗', 371) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (381, N'150428', N'喀喇沁旗', 371) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (382, N'150429', N'宁城县', 371) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (383, N'150430', N'敖汉旗', 371) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (384, N'150500', N'通辽市', 346) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (385, N'150502', N'科尔沁区', 384) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (386, N'150521', N'科尔沁左翼中旗', 384) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (387, N'150522', N'科尔沁左翼后旗', 384) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (388, N'150523', N'开鲁县', 384) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (389, N'150524', N'库伦旗', 384) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (390, N'150525', N'奈曼旗', 384) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (391, N'150526', N'扎鲁特旗', 384) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (392, N'150581', N'霍林郭勒市', 384) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (393, N'150600', N'鄂尔多斯市', 346) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (394, N'150602', N'东胜区', 393) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (395, N'150603', N'康巴什区', 393) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (396, N'150621', N'达拉特旗', 393) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (397, N'150622', N'准格尔旗', 393) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (398, N'150623', N'鄂托克前旗', 393) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (399, N'150624', N'鄂托克旗', 393) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (400, N'150625', N'杭锦旗', 393) GO INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (401, N'150626', N'乌审旗', 393) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (402, N'150627', N'伊金霍洛旗', 393) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (403, N'150700', N'呼伦贝尔市', 346) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (404, N'150702', N'海拉尔区', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (405, N'150703', N'扎赉诺尔区', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (406, N'150721', N'阿荣旗', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (407, N'150722', N'莫力达瓦达斡尔族自治旗', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (408, N'150723', N'鄂伦春自治旗', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (409, N'150724', N'鄂温克族自治旗', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (410, N'150725', N'陈巴尔虎旗', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (411, N'150726', N'新巴尔虎左旗', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (412, N'150727', N'新巴尔虎右旗', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (413, N'150781', N'满洲里市', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (414, N'150782', N'牙克石市', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (415, N'150783', N'扎兰屯市', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (416, N'150784', N'额尔古纳市', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (417, N'150785', N'根河市', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (418, N'150800', N'巴彦淖尔市', 346) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (419, N'150802', N'临河区', 418) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (420, N'150821', N'五原县', 418) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (421, N'150822', N'磴口县', 418) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (422, N'150823', N'乌拉特前旗', 418) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (423, N'150824', N'乌拉特中旗', 418) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (424, N'150825', N'乌拉特后旗', 418) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (425, N'150826', N'杭锦后旗', 418) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (426, N'150900', N'乌兰察布市', 346) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (427, N'150902', N'集宁区', 426) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (428, N'150921', N'卓资县', 426) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (429, N'150922', N'化德县', 426) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (430, N'150923', N'商都县', 426) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (431, N'150924', N'兴和县', 426) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (432, N'150925', N'凉城县', 426) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (433, N'150926', N'察哈尔右翼前旗', 426) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (434, N'150927', N'察哈尔右翼中旗', 426) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (435, N'150928', N'察哈尔右翼后旗', 426) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (436, N'150929', N'四子王旗', 426) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (437, N'150981', N'丰镇市', 426) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (438, N'152200', N'兴安盟', 346) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (439, N'152201', N'乌兰浩特市', 438) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (440, N'152202', N'阿尔山市', 438) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (441, N'152221', N'科尔沁右翼前旗', 438) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (442, N'152222', N'科尔沁右翼中旗', 438) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (443, N'152223', N'扎赉特旗', 438) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (444, N'152224', N'突泉县', 438) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (445, N'152500', N'锡林郭勒盟', 346) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (446, N'152501', N'二连浩特市', 445) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (447, N'152502', N'锡林浩特市', 445) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (448, N'152522', N'阿巴嘎旗', 445) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (449, N'152523', N'苏尼特左旗', 445) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (450, N'152524', N'苏尼特右旗', 445) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (451, N'152525', N'东乌珠穆沁旗', 445) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (452, N'152526', N'西乌珠穆沁旗', 445) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (453, N'152527', N'太仆寺旗', 445) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (454, N'152528', N'镶黄旗', 445) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (455, N'152529', N'正镶白旗', 445) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (456, N'152530', N'正蓝旗', 445) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (457, N'152531', N'多伦县', 445) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (458, N'152900', N'阿拉善盟', 346) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (459, N'152921', N'阿拉善左旗', 458) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (460, N'152922', N'阿拉善右旗', 458) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (461, N'152923', N'额济纳旗', 458) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (462, N'210000', N'辽宁省', 0) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (463, N'210100', N'沈阳市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (464, N'210102', N'和平区', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (465, N'210103', N'沈河区', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (466, N'210104', N'大东区', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (467, N'210105', N'皇姑区', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (468, N'210106', N'铁西区', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (469, N'210111', N'苏家屯区', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (470, N'210112', N'浑南区', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (471, N'210113', N'沈北新区', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (472, N'210114', N'于洪区', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (473, N'210115', N'辽中区', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (474, N'210123', N'康平县', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (475, N'210124', N'法库县', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (476, N'210181', N'新民市', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (477, N'210200', N'大连市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (478, N'210202', N'中山区', 477) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (479, N'210203', N'西岗区', 477) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (480, N'210204', N'沙河口区', 477) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (481, N'210211', N'甘井子区', 477) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (482, N'210212', N'旅顺口区', 477) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (483, N'210213', N'金州区', 477) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (484, N'210214', N'普兰店区', 477) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (485, N'210224', N'长海县', 477) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (486, N'210281', N'瓦房店市', 477) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (487, N'210283', N'庄河市', 477) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (488, N'210300', N'鞍山市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (489, N'210302', N'铁东区', 488) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (490, N'210303', N'铁西区', 488) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (491, N'210304', N'立山区', 488) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (492, N'210311', N'千山区', 488) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (493, N'210321', N'台安县', 488) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (494, N'210323', N'岫岩满族自治县', 488) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (495, N'210381', N'海城市', 488) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (496, N'210400', N'抚顺市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (497, N'210402', N'新抚区', 496) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (498, N'210403', N'东洲区', 496) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (499, N'210404', N'望花区', 496) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (500, N'210411', N'顺城区', 496) GO INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (501, N'210421', N'抚顺县', 496) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (502, N'210422', N'新宾满族自治县', 496) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (503, N'210423', N'清原满族自治县', 496) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (504, N'210500', N'本溪市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (505, N'210502', N'平山区', 504) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (506, N'210503', N'溪湖区', 504) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (507, N'210504', N'明山区', 504) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (508, N'210505', N'南芬区', 504) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (509, N'210521', N'本溪满族自治县', 504) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (510, N'210522', N'桓仁满族自治县', 504) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (511, N'210600', N'丹东市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (512, N'210602', N'元宝区', 511) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (513, N'210603', N'振兴区', 511) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (514, N'210604', N'振安区', 511) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (515, N'210624', N'宽甸满族自治县', 511) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (516, N'210681', N'东港市', 511) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (517, N'210682', N'凤城市', 511) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (518, N'210700', N'锦州市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (519, N'210702', N'古塔区', 518) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (520, N'210703', N'凌河区', 518) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (521, N'210711', N'太和区', 518) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (522, N'210726', N'黑山县', 518) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (523, N'210727', N'义县', 518) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (524, N'210781', N'凌海市', 518) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (525, N'210782', N'北镇市', 518) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (526, N'210800', N'营口市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (527, N'210802', N'站前区', 526) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (528, N'210803', N'西市区', 526) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (529, N'210804', N'鲅鱼圈区', 526) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (530, N'210811', N'老边区', 526) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (531, N'210881', N'盖州市', 526) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (532, N'210882', N'大石桥市', 526) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (533, N'210900', N'阜新市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (534, N'210902', N'海州区', 533) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (535, N'210903', N'新邱区', 533) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (536, N'210904', N'太平区', 533) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (537, N'210905', N'清河门区', 533) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (538, N'210911', N'细河区', 533) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (539, N'210921', N'阜新蒙古族自治县', 533) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (540, N'210922', N'彰武县', 533) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (541, N'211000', N'辽阳市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (542, N'211002', N'白塔区', 541) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (543, N'211003', N'文圣区', 541) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (544, N'211004', N'宏伟区', 541) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (545, N'211005', N'弓长岭区', 541) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (546, N'211011', N'太子河区', 541) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (547, N'211021', N'辽阳县', 541) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (548, N'211081', N'灯塔市', 541) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (549, N'211100', N'盘锦市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (550, N'211102', N'双台子区', 549) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (551, N'211103', N'兴隆台区', 549) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (552, N'211104', N'大洼区', 549) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (553, N'211122', N'盘山县', 549) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (554, N'211200', N'铁岭市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (555, N'211202', N'银州区', 554) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (556, N'211204', N'清河区', 554) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (557, N'211221', N'铁岭县', 554) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (558, N'211223', N'西丰县', 554) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (559, N'211224', N'昌图县', 554) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (560, N'211281', N'调兵山市', 554) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (561, N'211282', N'开原市', 554) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (562, N'211300', N'朝阳市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (563, N'211302', N'双塔区', 562) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (564, N'211303', N'龙城区', 562) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (565, N'211321', N'朝阳县', 562) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (566, N'211322', N'建平县', 562) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (567, N'211324', N'喀喇沁左翼蒙古族自治县', 562) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (568, N'211381', N'北票市', 562) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (569, N'211382', N'凌源市', 562) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (570, N'211400', N'葫芦岛市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (571, N'211402', N'连山区', 570) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (572, N'211403', N'龙港区', 570) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (573, N'211404', N'南票区', 570) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (574, N'211421', N'绥中县', 570) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (575, N'211422', N'建昌县', 570) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (576, N'211481', N'兴城市', 570) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (577, N'220000', N'吉林省', 0) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (578, N'220100', N'长春市', 577) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (579, N'220102', N'南关区', 578) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (580, N'220103', N'宽城区', 578) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (581, N'220104', N'朝阳区', 578) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (582, N'220105', N'二道区', 578) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (583, N'220106', N'绿园区', 578) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (584, N'220112', N'双阳区', 578) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (585, N'220113', N'九台区', 578) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (586, N'220122', N'农安县', 578) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (587, N'220182', N'榆树市', 578) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (588, N'220183', N'德惠市', 578) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (589, N'220200', N'吉林市', 577) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (590, N'220202', N'昌邑区', 589) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (591, N'220203', N'龙潭区', 589) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (592, N'220204', N'船营区', 589) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (593, N'220211', N'丰满区', 589) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (594, N'220221', N'永吉县', 589) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (595, N'220281', N'蛟河市', 589) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (596, N'220282', N'桦甸市', 589) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (597, N'220283', N'舒兰市', 589) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (598, N'220284', N'磐石市', 589) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (599, N'220300', N'四平市', 577) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (600, N'220302', N'铁西区', 599) GO INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (601, N'220303', N'铁东区', 599) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (602, N'220322', N'梨树县', 599) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (603, N'220323', N'伊通满族自治县', 599) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (604, N'220381', N'公主岭市', 599) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (605, N'220382', N'双辽市', 599) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (606, N'220400', N'辽源市', 577) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (607, N'220402', N'龙山区', 606) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (608, N'220403', N'西安区', 606) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (609, N'220421', N'东丰县', 606) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (610, N'220422', N'东辽县', 606) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (611, N'220500', N'通化市', 577) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (612, N'220502', N'东昌区', 611) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (613, N'220503', N'二道江区', 611) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (614, N'220521', N'通化县', 611) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (615, N'220523', N'辉南县', 611) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (616, N'220524', N'柳河县', 611) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (617, N'220581', N'梅河口市', 611) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (618, N'220582', N'集安市', 611) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (619, N'220600', N'白山市', 577) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (620, N'220602', N'浑江区', 619) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (621, N'220605', N'江源区', 619) INSERT [dbo
sqlserver是用触发器来实现 insert 后 返回自增 行的id号
CREATE TRIGGER DimGeography_Insert ON dbo.DimGeography FOR INSERT AS SELECT @@IDENTITY GO 如上所示: 我创建了一个 名为 DimGeography_Insert 的触发器, 专门处理DimGeography 的 INSERT 操作 , 返回自增ID
在Insert Into...中采用变量的方法
 在ASP数据库编程时,经常使用Request对象获取传递的信息,实现数据库的操作,如下: 将获取的信息赋值给变量 rfname = Request.Form("firstname") rlname = Request.Form("lastname") rsex = Request.Form("sex") rage = Request.Form("age")  ...... 插入语句,通过使用
数据库触发器---简单入门
1.今天给大家来个简单的触发器 2.创建个学生表 create table t_student(id int not null priamry key ,name varchar(10),createdate datetime); DELIMITER //   分界符 CREATE TRIGGER  tr_t_i   创建触发器 名字tr_t_i    BEFORE  INSERT ON
如何用insert into values插入多条数据
insert into 表名(字段名1,字段名2)values(值a1,值b1), (值a2,值b2), 例如: insert into user_info (user_account,user_name,user_age,user_class) values ('00001', '张三 ','20','计算机系'), ('00002', '李四','19','计算机系');
关闭