SuqianHome的专栏

标准三级省市区分类，code 采用政府标准代码，包含邮编 create table dmt_areas ( ID int identity, sys_code nvarchar(100) NULL , sys_type nvarchar(20) NULL , sys_name nvarchar(100) NULL , sys_parent nvarchar(100) NULL , sys_zip nvarchar(30) NULL , rowstatus int default 0 ) GO insert into dmt_areas (sys_code,sys_type,sys_name,sys_parent,sys_zip,rowstatus) values ('110000','1','北京','0','',0) insert into dmt_areas (sys_code,sys_type,sys_name,sys_parent,sys_zip,rowstatus) values ('110100','2','北京市','110000','100000',0) insert into dmt_areas (sys_code,sys_type,sys_name,sys_parent,sys_zip,rowstatus) values ('110101','3','东城区','110100','100010',0) insert into dmt_areas (sys_code,sys_type,sys_name,sys_parent,sys_zip,rowstatus) values ('110102','3','西城区','110100','100032',0) insert into dmt_areas (sys_code,sys_type,sys_name,sys_parent,sys_zip,rowstatus) values ('110103','3','崇文区','110100','100061',0) insert into dmt_areas (sys_code,sys_type,sys_name,sys_parent,sys_zip,rowstatus) values ('110104','3','宣武区','110100','100054',0) insert into dmt_areas (sys_code,sys_type,sys_name,sys_parent,sys_zip,rowstatus) values ('110105','3','朝阳区','110100','100011',0) insert into dmt_areas (sys_code,sys_type,sys_name,sys_parent,sys_zip,rowstatus) values ('110106','3','丰台区','110100','100071',0) insert into dmt_areas (sys_code,sys_type,sys_name,sys_parent,sys_zip,rowstatus) values ('110107','3','石景山区','110100','100071',0) ................................. .................................... ..........................................