《中国省市县(区)信息数据库》.docVIP

曾志红 2013-2-06 当前 PAGE 74总 NUMPAGES 74  TOC \o 1-3 \h \z \u  HYPERLINK \l _Toc347921889 --创建DBPromary数据库  PAGEREF _Toc347921889 \h 1  HYPERLINK \l _Toc347921890 --创建Province表  PAGEREF _Toc347921890 \h 1  HYPERLINK \l _Toc347921891 插入数据  PAGEREF _Toc347921891 \h 1  HYPERLINK \l _Toc347921892 创建City表  PAGEREF _Toc347921892 \h 2  HYPERLINK \l _Toc347921893 插入数据  PAGEREF _Toc347921893 \h 2  HYPERLINK \l _Toc347921894 创建县区表  PAGEREF _Toc347921894 \h 10  HYPERLINK \l _Toc347921895 插入数据  PAGEREF _Toc347921895 \h 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) i