provincecityarea.sql

三层无刷新级联选择省市区县 C#语言开发SQL 数据库(含全国完整数据库)Ajax无刷新三级联动

create database ProvinceCityArea
go
use ProvinceCityArea
go 

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,
[code] [nvarchar]  (12) NULL,
[name] [nvarchar]  (80) NULL)

INSERT [province] ([id],[code],[name]) VALUES ( 1,'110000','北京市')
INSERT [province] ([id],[code],[name]) VALUES ( 2,'120000','天津市')
INSERT [province] ([id],[code],[name]) VALUES ( 3,'130000','河北省')
INSERT [province] ([id],[code],[name]) VALUES ( 4,'140000','山西省')
INSERT [province] ([id],[code],[name]) VALUES ( 5,'150000','内蒙古')
INSERT [province] ([id],[code],[name]) VALUES ( 6,'210000','辽宁省')
INSERT [province] ([id],[code],[name]) VALUES ( 7,'220000','吉林省')
INSERT [province] ([id],[code],[name]) VALUES ( 8,'230000','黑龙江')
INSERT [province] ([id],[code],[name]) VALUES ( 9,'310000','上海市')
INSERT [province] ([id],[code],[name]) VALUES ( 10,'320000','江苏省')
INSERT [province] ([id],[code],[name]) VALUES ( 11,'330000','浙江省')
INSERT [province] ([id],[code],[name]) VALUES ( 12,'340000','安徽省')
INSERT [province] ([id],[code],[name]) VALUES ( 13,'350000','福建省')
INSERT [province] ([id],[code],[name]) VALUES ( 14,'360000','江西省')
INSERT [province] ([id],[code],[name]) VALUES ( 15,'370000','山东省')
INSERT [province] ([id],[code],[name]) VALUES ( 16,'410000','河南省')
INSERT [province] ([id],[code],[name]) VALUES ( 17,'420000','湖北省')
INSERT [province] ([id],[code],[name]) VALUES ( 18,'430000','湖南省')
INSERT [province] ([id],[code],[name]) VALUES ( 19,'440000','广东省')
INSERT [province] ([id],[code],[name]) VALUES ( 20,'450000','广  西')
INSERT [province] ([id],[code],[name]) VALUES ( 21,'460000','海南省')
INSERT [province] ([id],[code],[name]) VALUES ( 22,'500000','重庆市')
INSERT [province] ([id],[code],[name]) VALUES ( 23,'510000','四川省')
INSERT [province] ([id],[code],[name]) VALUES ( 24,'520000','贵州省')
INSERT [province] ([id],[code],[name]) VALUES ( 25,'530000','云南省')
INSERT [province] ([id],[code],[name]) VALUES ( 26,'540000','西  藏')
INSERT [province] ([id],[code],[name]) VALUES ( 27,'610000','陕西省')
INSERT [province] ([id],[code],[name]) VALUES ( 28,'620000','甘肃省')
INSERT [province] ([id],[code],[name]) VALUES ( 29,'630000','青海省')
INSERT [province] ([id],[code],[name]) VALUES ( 30,'640000','宁  夏')
INSERT [province] ([id],[code],[name]) VALUES ( 31,'650000','新  疆')
INSERT [province] ([id],[code],[name]) VALUES ( 32,'710000','台湾省')
INSERT [province] ([id],[code],[name]) VALUES ( 33,'810000','香  港')
INSERT [province] ([id],[code],[name]) VALUES ( 34,'820000','澳  门')
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,
[code] [nvarchar]  (12) NULL,
[name] [nvarchar]  (100) NULL,
[provinceId] [nvarchar]  (12) NULL)

INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 1,'110100','北京市','110000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 5,'130100','石家庄市','130000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 6,'130200','唐山市','130000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 7,'130300','秦皇岛市','130000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 8,'130400','邯郸市','130000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 9,'130500','邢台市','130000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 10,'130600','保定市','130000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 11,'130700','张家口市','130000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 12,'130800','承德市','130000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 13,'130900','沧州市','130000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 14,'131000','廊坊市','130000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 15,'131100','衡水市','130000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 16,'140100','太原市','140000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 17,'140200','大同市','140000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 18,'140300','阳泉市','140000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 19,'140400','长治市','140000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 20,'140500','晋城市','140000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 21,'140600','朔州市','140000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 22,'140700','晋中市','140000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 23,'140800','运城市','140000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 24,'140900','忻州市','140000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 25,'141000','临汾市','140000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 26,'141100','吕梁市','140000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 27,'150100','呼和浩特市','150000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 28,'150200','包头市','150000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 29,'150300','乌海市','150000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 30,'150400','赤峰市','150000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 31,'150500','通辽市','150000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 32,'150600','鄂尔多斯市','150000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 33,'150700','呼伦贝尔市','150000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 34,'150800','巴彦淖尔市','150000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 35,'150900','乌兰察布市','150000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 36,'152200','兴安盟','150000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 37,'152500','锡林郭勒盟','150000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 38,'152900','阿拉善盟','150000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 39,'210100','沈阳市','210000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 40,'210200','大连市','210000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 41,'210300','鞍山市','210000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 42,'210400','抚顺市','210000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 43,'210500','本溪市','210000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 44,'210600','丹东市','210000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 45,'210700','锦州市','210000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 46,'210800','营口市','210000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 47,'210900','阜新市','210000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 48,'211000','辽阳市','210000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 49,'211100','盘锦市','210000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 50,'211200','铁岭市','210000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 51,'211300','朝阳市','210000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 52,'211400','葫芦岛市','210000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 53,'220100','长春市','220000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 54,'220200','吉林市','220000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 55,'220300','四平市','220000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 56,'220400','辽源市','220000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 57,'220500','通化市','220000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 58,'220600','白山市','220000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 59,'220700','松原市','220000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 60,'220800','白城市','220000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 61,'222400','延边朝鲜族自治州','220000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 62,'230100','哈尔滨市','230000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 63,'230200','齐齐哈尔市','230000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 64,'230300','鸡西市','230000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 65,'230400','鹤岗市','230000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 66,'230500','双鸭山市','230000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 67,'230600','大庆市','230000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 68,'230700','伊春市','230000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 69,'230800','佳木斯市','230000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 70,'230900','七台河市','230000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 71,'231000','牡丹江市','230000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 72,'231100','黑河市','230000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 73,'231200','绥化市','230000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 74,'232700','大兴安岭地区','230000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 75,'310100','市辖区','310000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 76,'310200','县','310000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 77,'320100','南京市','320000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 78,'320200','无锡市','320000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 79,'320300','徐州市','320000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 80,'320400','常州市','320000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 81,'320500','苏州市','320000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 82,'320600','南通市','320000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 83,'320700','连云港市','320000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 84,'320800','淮安市','320000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 85,'320900','盐城市','320000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 86,'321000','扬州市','320000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 87,'321100','镇江市','320000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 88,'321200','泰州市','320000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 89,'321300','宿迁市','320000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 90,'330100','杭州市','330000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 91,'330200','宁波市','330000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 92,'330300','温州市','330000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 93,'330400','嘉兴市','330000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 94,'330500','湖州市','330000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 95,'330600','绍兴市','330000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 96,'330700','金华市','330000')