日期:2014-05-17 浏览次数:20487 次
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','西青区')
INS