SQL创建省级表.docx
- 文档编号:29206849
- 上传时间:2023-07-21
- 格式:DOCX
- 页数:170
- 大小:46.75KB
SQL创建省级表.docx
《SQL创建省级表.docx》由会员分享,可在线阅读,更多相关《SQL创建省级表.docx(170页珍藏版)》请在冰豆网上搜索。
SQL创建省级表
/**********创建省级表**********/
CREATE TABLE T_Province
(
ProID INT IDENTITY(1,1) PRIMARY KEY, --省份主键
ProName NVARCHAR(50) NOT NULL, --省份名称
ProSort INT, --省份排序
ProRemark NVARCHAR(50) --说明
)
Go
insert T_Province(ProName,ProSort,ProRemark) Values('北京市','1','直辖市')
insert T_Province(ProName,ProSort,ProRemark) Values('天津市','2','直辖市')
insert T_Province(ProName,ProSort,ProRemark) Values('河北省','5','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('山西省','6','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('内蒙古自治区','32','自治区')
insert T_Province(ProName,ProSort,ProRemark) Values('辽宁省','8','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('吉林省','9','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('黑龙江省','10','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('上海市','3','直辖市')
insert T_Province(ProName,ProSort,ProRemark) Values('江苏省','11','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('浙江省','12','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('安徽省','13','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('福建省','14','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('江西省','15','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('山东省','16','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('河南省','17','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('湖北省','18','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('湖南省','19','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('广东省','20','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('海南省','24','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('广西壮族自治区','28','自治区')
insert T_Province(ProName,ProSort,ProRemark) Values('甘肃省','21','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('陕西省','27','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('新 疆维吾尔自治区','31','自治区')
insert T_Province(ProName,ProSort,ProRemark) Values('青海省','26','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('宁夏回族自治区','30','自治区')
insert T_Province(ProName,ProSort,ProRemark) Values('重庆市','4','直辖市')
insert T_Province(ProName,ProSort,ProRemark) Values('四川省','22','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('贵州省','23','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('云南省','25','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('西藏自治区','29','自治区')
insert T_Province(ProName,ProSort,ProRemark) Values('台湾省','7','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('澳门特别行政区','33','特别行政区')
insert T_Province(ProName,ProSort,ProRemark) Values('香港特别行政区','34','特别行政区')
/********创建市级表********/
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,Pro
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- SQL 创建 省级