INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',1,'Ӫҵת','6001','4103','','һԶ','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',2,'ҵת','6051','4103','','һԶ','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',3,'ʼֵ䶯ת','6101','4103','','һԶ','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',4,'Ͷת','6111','4103','','һԶ','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',5,'Ӫҵת','6301','4103','','һԶ','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',6,'Ӫҵɱת','6401','4103','','һԶ','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',7,'ҵɱת','6402','4103','','һԶ','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',8,'˰𼰸ת','6403','4103','','һԶ','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',9,'۷ת','6601','4103','','һԶ','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',10,'ת','6602','4103','','һԶ','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',11,'ת','6603','4103','','һԶ','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',12,'ʲֵʧת','6701','4103','','һԶ','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',13,'Ӫҵ֧ת','6711','4103','','һԶ','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',14,'˰ת','6801','4103','','һԶ','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',15,'ǰת','6901','4103','','һԶ','n','')

UPDATE [a_ztcs] SET jzxscb_kcsp='1405',jzxscb_zyywcb='6401',jzxscb_zyywsr='6001',jzxscb_gs='1'

INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( 'Ʒṩյֽ','101',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( 'յ˰ѷ','102',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( 'յ뾭Ӫйصֽ','103',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( 'Ʒֽ֧','104',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( 'ְ֧ԼΪְֽ֧','105',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '֧ĸ˰','106',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '֧뾭Ӫйصֽ','107',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( 'ջͶյֽ','201',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( 'ȡͶյֽ','202',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( 'ù̶ʲʲʲջصֽ𾻶','203',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( 'ӹ˾Ӫҵλյֽ𾻶','204',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( 'յͶʻйصֽ','205',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '̶ʲʲʲֽ֧','206',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( 'Ͷֽ֧','207',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( 'ȡӹ˾Ӫҵλֽ֧𾻶','208',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '֧Ͷʻйصֽ','209',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( 'Ͷյֽ','301',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( 'ȡýյֽ','302',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( 'յʻйصֽ','303',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( 'ծֽ֧','304',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '򳥸Ϣֽ֧','305',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '֧ʻйصֽ','306',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( 'ʱ䶯ֽӰ','401',2019,'xjl','y')

UPDATE [a_kjkm] SET xjl='y' WHERE left(kmbm,4)='1001' OR left(kmbm,4)='1002' OR left(kmbm,4)='1012'
