全国省份/城市表(sql版)
前段时间感觉现在正在用的全国省份/城市表不是太好,于是想换一个新的,没想到上网找了好久都没有找到合适的,于是上国家统计局网站上拷了一份最新的有关区域名称的本文回来,最后花半天时间整理了一下,终于改为自己想要的格式了,想到还有许多朋友想要一份这样的数据表,故现公布如下:
国家统计局的网址:http://www.stats.gov.cn/tjbz/xzqhdm/t20070411_402397928.htm
数据库表结构:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Area]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Area]
GO
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
CREATE TABLE [dbo].[Area] (
[AreaID] [int] IDENTITY (1, 1) NOT NULL ,
[Name] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ParentID] [int] NULL
) ON [PRIMARY]
GO
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
ALTER TABLE [dbo].[Area] ADD
CONSTRAINT [PK_aa] PRIMARY KEY CLUSTERED
(
[AreaID]
) ON [PRIMARY]
GO
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
国家统计局的网址:http://www.stats.gov.cn/tjbz/xzqhdm/t20070411_402397928.htm
数据库表结构:
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
数据内容我已导出成txt格式,因为数据库文件太大了,默认的就有1M。
下载
只要把下载的文件导入到前面建好的表中即可!
放一幅图出来look一look:
posted on 2007-07-17 14:57 lonewolf 阅读(14264) 评论(4) 编辑 收藏 举报