[计算机软件及应用]中国省市县区信息数据库.doc

--创建DBPromary数据库 1 --创建Province表 1 插入数据 1 创建City表 2 插入数据 2 创建县区表 10 插入数据 10 --创建DBPromary数据库 create database DBPromary use DBPromary go --创建Province表 CREATE TABLE [dbo].[Province]( [Id] [int] NULL, [Name] [varchar](50) NULL, [orderid] [int] NULL ) 插入数据 insert into Province values(1,北京,0) insert into Province values(2,天津,0) insert into Province values(3,河北,0) insert into Province values(4,山西,0) insert into Province values(5,内蒙古,0) insert into Province values(6,辽宁,0) insert into Province values(7,吉林,0) insert into Province values(8,黑龙江,0) insert into Province values(9,上海,0) insert into Province values(10,江苏,0) insert into Province values(11,浙江,0) insert into Province values(12,安徽,0) insert into Province values(13,福建,999) insert into Province values(14,江西,0) insert into Province values(15,山东,0) insert into Province values(16,河南,0) insert into Province values(17,湖北,0) insert into Province values(18,湖南,0) insert into Province values(19,广东,0) insert into Province values(20,广西,0) insert into Province values(21,海南,0) insert into Province values(22,重庆,0) insert into Province values(23,四川,0) insert into Province values(24,贵州,0) insert into Province values(25,云南,0) insert into Province values(26,西藏,0) insert into Province values(27,陕西,0) insert into Province values(28,甘肃,0) insert into Province values(29,青海,0) insert into Province values(30,宁夏,0) insert into Province values(31,新疆,0) insert into Province values(32,香港,0) insert into Province values(33,澳门,0) insert into Province values(34,台湾,0)City表 CREATE TABLE [dbo].[City]( [Id] [int] NULL, [ProvinceId] [int] NULL, [Name] [varchar](50) NULL, [AreaCode] [varchar](50) NULL ) 插入数据 insert into City values(1,1,北京市,010) insert into City values(2,2,天津市,022) insert into City values(3,3,石家庄市,0311) insert into City values(4,3,唐山市,0315) insert into City values(5,3,秦皇岛市,0335) insert into City values(6,3,邯郸市,0310) insert into City values(7,3,邢台市,0319) insert into City values(8,3,保定市,0312) ins