标准三级省市区分类,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)
.................................
....................................
..........................................