2012年地址区域结构（基于标准行政区域代码、内含邮编）

if exists (select * from sysobjects where id = OBJECT_ID('[Province]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) --省份 DROP TABLE [Province] CREATE TABLE [Province] ( [Id] [int] NOT NULL, [Name] [nvarchar] (50) NULL, [ParentId] [int] NULL, [Type] [int] NULL) ALTER TABLE [Province] WITH NOCHECK ADD CONSTRAINT [PK_Province] PRIMARY KEY NONCLUSTERED ( [Id] ) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 1,N'全部省份',0,1) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 110000,N'北京',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 120000,N'天津',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 130000,N'河北省',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 140000,N'山西省',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 150000,N'内蒙古自治区',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 210000,N'辽宁省',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 220000,N'吉林省',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 230000,N'黑龙江省',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 310000,N'上海',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 320000,N'江苏省',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 330000,N'浙江省',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 340000,N'安徽省',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 350000,N'福建省',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 360000,N'江西省',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 370000,N'山东省',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 410000,N'河南省',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 420000,N'湖北省',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 430000,N'湖南省',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 440000,N'广东省',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 450000,N'广西壮族自治区',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 460000,N'海南省',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 500000,N'重庆',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 510000,N'四川省',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 520000,N'贵州省',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 530000,N'云南省',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 540000,N'西藏自治区',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 610000,N'陕西省',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 620000,N'甘肃省',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 630000,N'青海省',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 640000,N'宁夏回族自治区',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 650000,N'新疆维吾尔自治区',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 710000,N'台湾省',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 810000,N'香港特别行政区',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 820000,N'澳门特别行政区',1,2) INSERT [Province] ([Id],[Name],[ParentId],[Type]) VALUES ( 990000,N'海外',1,2) if exists (select * from sysobjects where id = OBJECT_ID('[City]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) --城市 DROP TABLE [City] CREATE TABLE [City] ( [Id] [int] NOT NULL, [Name] [nvarchar] (50) NULL, [ParentId] [int] NULL, [Type] [int] NULL, [Zip] [int] NULL) ALTER TABLE [City] WITH NOCHECK ADD CONSTRAINT [PK_City] PRIMARY KEY NONCLUSTERED ( [Id] ) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 110100,N'北京市',110000,3,100000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 120100,N'天津市',120000,3,300000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 130100,N'石家庄市',130000,3,50000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 130200,N'唐山市',130000,3,63000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 130300,N'秦皇岛市',130000,3,66000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 130400,N'邯郸市',130000,3,56000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 130500,N'邢台市',130000,3,54000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 130600,N'保定市',130000,3,71000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 130700,N'张家口市',130000,3,75000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 130800,N'承德市',130000,3,67000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 130900,N'沧州市',130000,3,61000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 131000,N'廊坊市',130000,3,65000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 131100,N'衡水市',130000,3,53000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 140100,N'太原市',140000,3,30000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 140200,N'大同市',140000,3,37000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 140300,N'阳泉市',140000,3,45000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 140400,N'长治市',140000,3,46000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 140500,N'晋城市',140000,3,48000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 140600,N'朔州市',140000,3,36000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 140700,N'晋中市',140000,3,30600) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 140800,N'运城市',140000,3,44000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 140900,N'忻州市',140000,3,34000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 141000,N'临汾市',140000,3,41000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 141100,N'吕梁市',140000,3,33000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 150100,N'呼和浩特市',150000,3,10000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 150200,N'包头市',150000,3,14000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 150300,N'乌海市',150000,3,16000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 150400,N'赤峰市',150000,3,24000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 150500,N'通辽市',150000,3,28000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 150600,N'鄂尔多斯市',150000,3,17004) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 150700,N'呼伦贝尔市',150000,3,21008) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 150800,N'巴彦淖尔市',150000,3,15001) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 150900,N'乌兰察布市',150000,3,12000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 152200,N'兴安盟',150000,3,137401) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 152500,N'锡林郭勒盟',150000,3,26021) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 152900,N'阿拉善盟',150000,3,750306) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 210100,N'沈阳市',210000,3,110000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 210200,N'大连市',210000,3,116000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 210300,N'鞍山市',210000,3,114000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 210400,N'抚顺市',210000,3,113000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 210500,N'本溪市',210000,3,117000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 210600,N'丹东市',210000,3,118000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 210700,N'锦州市',210000,3,121000) INSERT [City] ([Id],[Name],[ParentId],[Type],[Zip]) VALUES ( 210800,N'营口市',210000,3,115000) INSERT [City] ([Id]