日期:2014-05-18 浏览次数:20377 次
CREATE TABLE Province(ID INT Primary Key ,Name nvarchar(50)) CREATE TABLE City(ID INT Primary Key ,Name nvarchar(50)) INSERT INTO Province(ID,Name)VALUES('1','北京') INSERT INTO City(ID,Name)VALUES('1','东城区') INSERT INTO City(ID,Name)VALUES('2','西城区') INSERT INTO City(ID,Name)VALUES('3','宣武区') INSERT INTO City(ID,Name)VALUES('4','崇文区') INSERT INTO City(ID,Name)VALUES('5','朝阳区') INSERT INTO City(ID,Name)VALUES('6','海淀区') INSERT INTO City(ID,Name)VALUES('7','丰台区') INSERT INTO City(ID,Name)VALUES('8','石景山区') INSERT INTO City(ID,Name)VALUES('9','门头沟区') INSERT INTO City(ID,Name)VALUES('10','昌平区') INSERT INTO City(ID,Name)VALUES('11','大兴区') INSERT INTO City(ID,Name)VALUES('12','怀柔区') INSERT INTO City(ID,Name)VALUES('13','密云县') INSERT INTO City(ID,Name)VALUES('14','平谷区') INSERT INTO City(ID,Name)VALUES('15','顺义区') INSERT INTO City(ID,Name)VALUES('16','通州区') INSERT INTO City(ID,Name)VALUES('17','延庆县') INSERT INTO City(ID,Name)VALUES('103','房山区') INSERT INTO Province(ID,Name)VALUES('2','上海') INSERT INTO City(ID,Name)VALUES('18','黄浦区') INSERT INTO City(ID,Name)VALUES('19','南市区') INSERT INTO City(ID,Name)VALUES('20','卢湾区') INSERT INTO City(ID,Name)VALUES('21','徐汇区') INSERT INTO City(ID,Name)VALUES('22','长宁区') INSERT INTO City(ID,Name)VALUES('23','静安区') INSERT INTO City(ID,Name)VALUES('24','普陀区') INSERT INTO City(ID,Name)VALUES('25','金山区') INSERT INTO City(ID,Name)VALUES('26','闸北区') INSERT INTO City(ID,Name)VALUES('27','虹口区') INSERT INTO City(ID,Name)VALUES('28','杨浦区') INSERT INTO City(ID,Name)VALUES('29','宝山区') INSERT INTO City(ID,Name)VALUES('30','闵行区') INSERT INTO City(ID,Name)VALUES('31','嘉定区') INSERT INTO City(ID,Name)VALUES('32','松江区') INSERT INTO City(ID,Name)VALUES('33','浦东新区') INSERT INTO City(ID,Name)VALUES('34','青浦县') INSERT INTO City(ID,Name)VALUES('35','奉贤县') INSERT INTO City(ID,Name)VALUES('36','南汇县') INSERT INTO City(ID,Name)VALUES('37','崇明县') INSERT INTO Province(ID,Name)VALUES('3','天津') INSERT INTO City(ID,Name)VALUES('38','和平区') INSERT INTO City(ID,Name)VALUES('39','河东区') INSERT INTO City(ID,Name)VALUES('40','河西区') INSERT INTO City(ID,Name)VALUES('41','河北区') INSERT INTO City(ID,Name)VALUES('42','南开区') INSERT INTO City(ID,Name)VALUES('43','红桥区') INSERT INTO City(ID,Name)VALUES('44','塘沽区') INSERT INTO City(ID,Name)VALUES('45','汉沽区') INSERT INTO City(ID,Name)VALUES('105','大港区') INSERT INTO City(ID,Name)VALUES('106','东丽区') INSERT INTO City(ID,Name)VALUES('107','西青区') INSERT INTO City(ID,Name)VALUES('108','津南区') INSERT INTO City(ID,Name)VALUES('109','北辰区') INSERT INTO City(ID,Name)VALUES('110',' 武清区') INSERT INTO City(ID,Name)VALUES('111','宝坻区') INSERT INTO City(ID,Name)VALUES('112','蓟 县') INSERT INTO City(ID,Name)VALUES('113','宁河县') INSERT INTO City(ID,Name)VALUES('114','静海县') INSERT INTO Province(ID,Name)VALUES('4',' 重庆') INSERT INTO City(ID,Name)VALUES('46','永川市') INSERT INTO City(ID,Name)VALUES('47','黔江区') INSERT INTO City(ID,Name)VALUES('48','涪陵区') INSERT INTO City(ID,Name)VALUES('49','万洲区') INSERT INTO City(ID,Name)VALUES('115','渝中区') INSERT INTO City(ID,Name)VALUES('116','大渡口区') INSERT INTO City(ID,Name)VALUES('117','江北区') INSERT INTO City(ID,Name)VALUES('118','沙坪坝区') INSERT INTO City(ID,Name)VALUES('119','九龙坡区') INSERT INTO City(ID,Name)VALUES('120','南岸区') INSERT INTO City(ID,Name)VALUES('121','北碚区') INSERT INTO City(ID,Name)VALUES('122',' 万盛区') INSERT INTO City(ID,Name)VALUES('123','双桥区') INSERT INTO City(ID,Name)VALUES('124','渝北区') INSERT INTO City(ID,Name)VALUES('125','巴南区') INSERT INTO City(ID,Name)VALUES('126','长寿区') INSERT INTO Province(ID,Name)VALUES('5',' 黑龙江') INSERT INTO City(ID,Name)VALUES('50','哈尔滨') INSERT INTO City(ID,Name)VALUES('51','齐齐哈尔') INSERT INTO City(ID,Name)VALUES('52','牡丹江') INSERT INT