全国省市区县数据库-市（全）
********创建市级表********/
CREATE TABLE T_City
(
CityID INT IDENTITY(1,1) Primary KEY , --城市主键
CityName NVARCHAR(50) NOT NULL, --城市名称
ProID INT, --所属省份
CitySort INT --城市排序
)
INSERT T_City(CityName,ProID,CitySort) Values('北京市','1','1')
INSERT T_City(CityName,ProID,CitySort) Values('天津市','2','2')
INSERT T_City(CityName,ProID,CitySort) Values('上海市','9','3')
INSERT T_City(CityName,ProID,CitySort) Values('重庆市','27','4')
INSERT T_City(CityName,ProID,CitySort) Values('邯郸市','3','5')
INSERT T_City(CityName,ProID,CitySort) Values('石家庄市','3','6')
INSERT T_City(CityName,ProID,CitySort) Values('保定市','3','7')
INSERT T_City(CityName,ProID,CitySort) Values('张家口市','3','8')
INSERT T_City(CityName,ProID,CitySort) Values('承德市','3','9')
INSERT T_City(CityName,ProID,CitySort) Values('唐山市','3','10')
INSERT T_City(CityName,ProID,CitySort) Values('廊坊市','3','11')
INSERT T_City(CityName,ProID,CitySort) Values('沧州市','3','12')
INSERT T_City(CityName,ProID,CitySort) Values('衡水市','3','13')
INSERT T_City(CityName,ProID,CitySort) Values('邢台市','3','14')
INSERT T_City(CityName,ProID,CitySort) Values('秦皇岛市','3','15')
INSERT T_City(CityName,ProID,CitySort) Values('朔州市','4','16')
INSERT T_City(CityName,ProID,CitySort) Values('忻州市','4','17')
INSERT T_City(CityName,ProID,CitySort) Values('太原市','4','18')
INSERT T_City(CityName,ProID,CitySort) Values('大同市','4','19')
INSERT T_City(CityName,ProID,CitySort) Values('阳泉市','4','20')
INSERT T_City(CityName,ProID,CitySort) Values('晋中市','4','21')
INSERT T_City(CityName,ProID,CitySort) Values('长治市','4','22')
INSERT T_City(CityName,ProID,CitySort) Values('晋城市','4','23')
INSERT T_City(CityName,ProID,CitySort) Values('临汾市','4','24')
INSERT T_City(CityName,ProID,CitySort) Values('吕梁市','4','25')
INSERT T_City(CityName,ProID,CitySort) Values('运城市','4','26')
INSERT T_City(CityName,ProID,CitySort) Values('沈阳市','6','27')
INSERT T_City(CityName,ProID,CitySort) Values('铁岭市','6','28')
INSERT T_City(CityName,ProID,CitySort) Values('大连市','6','29')
INSERT T_City(CityName,ProID,CitySort) Values('鞍山市','6','30')
INSERT T_City(CityName,ProID,CitySort) Values('抚顺市','6','31')
INSERT T_City(CityName,ProID,CitySort) Values('本溪市','6','32')
INSERT T_City(CityName,ProID,CitySort) Values('丹东市','6','33')
INSERT T_City(CityName,ProID,CitySort) Values('锦州市','6','34')
INSERT T_City(CityName,ProID,CitySort) Values('营口市','6','35')
INSERT T_City(CityName,ProID,CitySort) Values('阜新市','6','36')
INSERT T_City(CityName,ProID,CitySort) Values('辽阳市','6','37')
INSERT T_City(CityName,ProID,CitySort) Values('朝阳市','6','38')
INSERT T_City(CityName,ProID,CitySort) Values('盘锦市','6','39')
INSERT T_City(CityName,ProID,CitySort) Values('葫芦岛市','6','40')
INSERT T_City(CityName,ProID,CitySort) Values('长春市','7','41')
INSERT T_City(CityName,ProID,CitySort) Values('吉林市','7','42')
INSERT T_City(CityName,ProID,CitySort) Values('延边朝鲜族自治州','7','43')
INSERT T_City(CityName,ProID,CitySort) Values('四平市','7','44')
INSERT T_City(CityName,ProID,CitySort) Values('通化市','7','45')
INSERT T_City(CityName,ProID,CitySort) Values('白城市','7','46')
INSERT T_City(CityName,ProID,CitySort) Values('辽源市','7','47')
INSERT T_City(CityName,ProID,CitySort) Values('松原市','7','48')
INSERT T_City(CityName,ProID,CitySort) Values('白山市','7','49')
INSERT T_City(CityName,ProID,CitySort) Values('哈尔滨市','8','50')
INSERT T_City(CityName,ProID,CitySort) Values('齐齐哈尔市','8','51')
INSERT T_City(CityName,ProID,CitySort) Values('鸡西市','8','52')
INSERT T_City(CityName,ProID,CitySort) Values('牡丹江市','8','53')
INSERT T_City(CityName,ProID,CitySort) Values('七台河市','8','54')
INSERT T_City(CityName,ProID,CitySort) Values('佳木斯市','8','55')
INSERT T_City(CityName,ProID,CitySort) Values('鹤岗市','8','56')
INSERT T_City(CityName,ProID,CitySort) Values('双鸭山市','8','57')
INSERT T_City(CityName,ProID,CitySort) Values('绥化市','8','58')
INSERT T_City(CityName,ProID,CitySort) Values('黑河市','8','59')
INSERT T_City(CityName,ProID,CitySort) Values('大兴安岭地区','8','60')
INSERT T_City(CityName,ProID,CitySort) Values('伊春市','8','61')
INSERT T_City(CityName,ProID,CitySort) Values('大庆市','8','62')
INSERT T_City(CityName,ProID,CitySort) Values('南京市','10','63')
INSERT T_City(CityName,ProID,CitySort) Values('无锡市','10','64')
INSERT T_City(CityName,ProID,CitySort) Values('镇江市','10','65')
INSERT T_City(CityName,ProID,CitySort) Values('苏州市','10','66')
INSERT T_City(CityName,ProID,CitySort) Values('南通市','10','67')
INSERT T_City(CityName,ProID,CitySort) Values('扬州市','10','68')
INSERT T_City(CityName,ProID,CitySort) Values('盐城市','10','69')
INSERT T_City(CityName,ProID,CitySort) Values('徐州市','10','70')
INSERT T_City(CityName,ProID,CitySort) Values('淮安市','10','71')
INSERT T_City(CityName,ProID,CitySort) Values('连云港市','10','72')
INSERT T_City(CityName,ProID,CitySort) Values('常州市','10','73')
INSERT T_City(CityName,ProID,CitySort) Values('泰州市','10','74')
INSERT T_City(CityName,ProID,CitySort) Values('宿迁市','10','75')
INSERT T_City(CityName,ProID,CitySort) Values('舟山市','11','76')
INSERT T_City(CityName,ProID,CitySort) Values('衢州市','11','77')
INSERT T_City(CityName,ProID,CitySort) Values('杭州市','11','78')
INSERT T_City(CityName,ProID,CitySort) Values('湖州市','11','79')
INSERT T_City(CityName,ProID,CitySort) Values('嘉兴市','11','80')
INSERT T_City(CityName,ProID,CitySort) Values('宁波市','11','81')
INSERT T_City(CityName,ProID,CitySort) Values('绍兴市','11','82')
INSERT T_City(CityName,ProID,CitySort) Values('温州市','11','83')
INSERT T_City(CityName,ProID,CitySort) Values('丽水市','11','84')
INSERT T_City(CityName,ProID,CitySort) Values('金华市','11','85')
INSERT T_City(CityName,ProID,CitySort) Values('台州市','11','86')
INSERT T_City(CityName,ProID,CitySort) Values('合肥市','12','87')
INSERT T_City(CityName,ProID,CitySort) Values('芜湖市','12','88')
INSERT T_City(CityName,ProID,CitySort) Values('蚌埠市','12','89')
INSERT T_City(CityName,ProID,CitySort) Values('淮南市','12','90')
INSERT T_City(CityName,ProID,CitySort) Values('马鞍山市','12','91')
INSERT T_City(CityName,ProID,CitySort) Values('淮北市','12','92')
INSERT T_City(CityName,ProID,CitySort) Values('铜陵市','12','93')
INSERT T_City(CityName,ProID,CitySort) Values('安庆市','12','94')
INSERT T_City(CityName,ProID,CitySort) Values('黄山市','12','95')
INSERT T_City(CityName,ProID,CitySort) Values('滁州市','12','96')
INSERT T_City(CityName,ProID,CitySort) Values('阜阳市','12','97')
INSERT T_City(CityName,ProID,CitySort) Values('宿州市','12','98')
INSERT T_City(CityName,ProID,CitySort) Values('巢湖市','12','99')
INSERT T_City(CityName,ProID,CitySort) Values('六安市','12','100')
INSERT T_City(CityName,ProID,CitySort) Values('亳州市','12','101')
INSERT T_City(CityName,ProID,CitySort) Values('池州市','12','102')
INSERT T_City(CityName,ProID,CitySort) Values('宣城市','12','103')
INSERT T_City(CityName,ProID,CitySort) Values('福州市','13','104')
INSERT T_City(CityName,ProID,CitySort) Values('厦门市','13','105')
INSERT T_City(CityName,ProID,CitySort) Values('宁德市','13','106')
INSERT T_City(CityName,ProID,CitySort) Values('莆田市','13','107')
INSERT T_City(CityName,ProID,CitySort) Values('泉州市','13','108')
INSERT T_City(CityName,ProID,CitySort) Values('漳州市','13','109')
INSERT T_City(CityName,ProID,CitySort) Values('龙岩市','13','110')
INSERT T_City(CityName,ProID,CitySort) Values('三明市','13','111')
INSERT T_City(CityName,ProID,CitySort) Values('南平市','13','112')
INSERT T_City(CityName,ProID,CitySort) Values('鹰潭市','14','113')
INSERT T_City(CityName,ProID,CitySort) Values('新余市','14','114')
INSERT T_City(CityName,ProID,CitySort) Values('南昌市','14','115')
INSERT T_City(CityName,ProID,CitySort) Values('九江市','14','116')
INSERT T_City(CityName,ProID,CitySort) Values('上饶市','14','117')
INSERT T_City(CityName,ProID,CitySort) Values('抚州市','14','118')
INSERT T_City(CityName,ProID,CitySort) Values('宜春市','14','119')
INSERT T_City(CityName,ProID,CitySort) Values('吉安市','14','120')
INSERT T_City(CityName,ProID,CitySort) Values('赣州市','14','121')
INSERT T_City(CityName,ProID,CitySort) Values('景德镇市','14','122')
INSERT T_City(CityName,ProID,CitySort) Values('萍乡市','14','123')