全国省市SQL数据表Word文档格式.docx
- 文档编号:15298299
- 上传时间:2022-10-29
- 格式:DOCX
- 页数:59
- 大小:25.24KB
全国省市SQL数据表Word文档格式.docx
《全国省市SQL数据表Word文档格式.docx》由会员分享,可在线阅读,更多相关《全国省市SQL数据表Word文档格式.docx(59页珍藏版)》请在冰豆网上搜索。
BEGINTRANSACTION;
SELECTTOP10FROMTProvinceAndCityWITH(HOLDLOCK,TABLOCK);
DISABLETRIGGERALLONTProvinceAndCity;
SETIDENTITY_INSERTTProvinceAndCityON;
BEGINTRY
IFEXISTS(SELECTTOP10FROM[TProvinceAndCity]WHERE[Pkey]=1)
UPDATE[TProvinceAndCity]SETProvince=N'
北京市'
City=N'
西城区'
WHERE[Pkey]=1;
ELSE
INSERT[TProvinceAndCity](Pkey,Province,City)VALUES(1,N'
N'
);
IFEXISTS(SELECTTOP10FROM[TProvinceAndCity]WHERE[Pkey]=2)
崇文区'
WHERE[Pkey]=2;
INSERT[TProvinceAndCity](Pkey,Province,City)VALUES(2,N'
IFEXISTS(SELECTTOP10FROM[TProvinceAndCity]WHERE[Pkey]=3)
宣武区'
WHERE[Pkey]=3;
INSERT[TProvinceAndCity](Pkey,Province,City)VALUES(3,N'
IFEXISTS(SELECTTOP10FROM[TProvinceAndCity]WHERE[Pkey]=4)
朝阳区'
WHERE[Pkey]=4;
INSERT[TProvinceAndCity](Pkey,Province,City)VALUES(4,N'
IFEXISTS(SELECTTOP10FROM[TProvinceAndCity]WHERE[Pkey]=5)
丰台区'
WHERE[Pkey]=5;
INSERT[TProvinceAndCity](Pkey,Province,City)VALUES(5,N'
IFEXISTS(SELECTTOP10FROM[TProvinceAndCity]WHERE[Pkey]=6)
石景山区'
WHERE[Pkey]=6;
INSERT[TProvinceAndCity](Pkey,Province,City)VALUES(6,N'
IFEXISTS(SELECTTOP10FROM[TProvinceAndCity]WHERE[Pkey]=7)
海淀区'
WHERE[Pkey]=7;
INSERT[TProvinceAndCity](Pkey,Province,City)VALUES(7,N'
IFEXISTS(SELECTTOP10FROM[TProvinceAndCity]WHERE[Pkey]=8)
门头沟区'
WHERE[Pkey]=8;
INSERT[TProvinceAndCity](Pkey,Province,City)VALUES(8,N'
IFEXISTS(SELECTTOP10FROM[TProvinceAndCity]WHERE[Pkey]=9)
房山区'
WHERE[Pkey]=9;
INSERT[TProvinceAndCity](Pkey,Province,City)VALUES(9,N'
IFEXISTS(SELECTTOP10FROM[TProvinceAndCity]WHERE[Pkey]=10)
通州区'
WHERE[Pkey]=10;
INSERT[TProvinceAndCity](Pkey,Province,City)VALUES(10,N'
IFEXISTS(SELECTTOP10FROM[TProvinceAndCity]WHERE[Pkey]=11)
顺义区'
WHERE[Pkey]=11;
INSERT[TProvinceAndCity](Pkey,Province,City)VALUES(11,N'
IFEXISTS(SELECTTOP10FROM[TProvinceAndCity]WHERE[Pkey]=12)
昌平区'
WHERE[Pkey]=12;
INSERT[TProvinceAndCity](Pkey,Province,City)VALUES(12,N'
IFEXISTS(SELECTTOP10FROM[TProvinceAndCity]WHERE[Pkey]=13)
大兴区'
WHERE[Pkey]=13;
INSERT[TProvinceAndCity](Pkey,Province,City)VALUES(13,N'
IFEXISTS(SELECTTOP10FROM[TProvinceAndCity]WHERE[Pkey]=14)
怀柔区'
WHERE[Pkey]=14;
INSERT[TProvinceAndCity](Pkey,Province,City)VALUES(14,N'
IFEXISTS(SELECTTOP10FROM[TProvinceAndCity]WHERE[Pkey]=15)
平谷区'
WHERE[Pkey]=15;
INSERT[TProvinceAndCity](Pkey,Province,City)VALUES(15,N'
IFEXISTS(SELECTTOP10FROM[TProvinceAndCity]WHERE[Pkey]=16)
密云县'
WHERE[Pkey]=16;
INSERT[TProvinceAndCity](Pkey,Province,City)VALUES(16,N'
IFEXISTS(SELECTTOP10FROM[TProvinceAndCity]WHERE[Pkey]=17)
延庆县'
WHERE[Pkey]=17;
INSERT[TProvinceAndCity](Pkey,Province,City)VALUES(17,N'
IFEXISTS(SELECTTOP10FROM[TProvinceAndCity]WHERE[Pkey]=18)
上海市'
黄浦区'
WHERE[Pkey]=18;
INSERT[TProvinceAndCity](Pkey,Province,City)VALUES(18,N'
IFEXISTS(SELECTTOP10FROM[TProvinceAndCity]WHERE[Pkey]=19)
卢湾区'
WHERE[Pkey]=19;
INSERT[TProvinceAndCity](Pkey,Province,City)VALUES(19,N'
IFEXISTS(SELECTTOP10FROM[TProvinceAndCity]WHERE[Pkey]=20)
徐汇区'
WHERE[Pkey]=20;
INSERT[TProvinceAndCity](Pkey,Province,City)VALUES(20,N'
IFEXISTS(SELECTTOP10FROM[TProvinceAndCity]WHERE[Pkey]=
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 全国 省市 SQL 数据表