全国省市数据表(sql版)

最新推荐文章于 2024-04-16 11:07:50 发布

chuxue1342

最新推荐文章于 2024-04-16 11:07:50 发布

阅读量6.1k

点赞数 1

文章标签： sql insert null table 金山 360

本文链接：https://blog.csdn.net/chuxue1342/article/details/6546768

版权

drop table TProvinceAndCity
GO
Create Table TProvinceAndCity
(
PKey int identity(1,1) not null,
Province nvarchar(32) null,
City nvarchar(32) null
)
Go

BEGIN TRANSACTION ;
SELECT TOP 1 0 FROM TProvinceAndCity WITH(HOLDLOCK , TABLOCK) ;
DISABLE TRIGGER ALL ON TProvinceAndCity ;
SET IDENTITY_INSERT TProvinceAndCity ON ;
BEGIN TRY

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 1)
UPDATE [TProvinceAndCity] SET Province=N'北京市',City=N'西城区' WHERE [Pkey] = 1 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(1,N'北京市',N'西城区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 2)
UPDATE [TProvinceAndCity] SET Province=N'北京市',City=N'崇文区' WHERE [Pkey] = 2 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(2,N'北京市',N'崇文区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 3)
UPDATE [TProvinceAndCity] SET Province=N'北京市',City=N'宣武区' WHERE [Pkey] = 3 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(3,N'北京市',N'宣武区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 4)
UPDATE [TProvinceAndCity] SET Province=N'北京市',City=N'朝阳区' WHERE [Pkey] = 4 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(4,N'北京市',N'朝阳区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 5)
UPDATE [TProvinceAndCity] SET Province=N'北京市',City=N'丰台区' WHERE [Pkey] = 5 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(5,N'北京市',N'丰台区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 6)
UPDATE [TProvinceAndCity] SET Province=N'北京市',City=N'石景山区' WHERE [Pkey] = 6 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(6,N'北京市',N'石景山区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 7)
UPDATE [TProvinceAndCity] SET Province=N'北京市',City=N'海淀区' WHERE [Pkey] = 7 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(7,N'北京市',N'海淀区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 8)
UPDATE [TProvinceAndCity] SET Province=N'北京市',City=N'门头沟区' WHERE [Pkey] = 8 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(8,N'北京市',N'门头沟区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 9)
UPDATE [TProvinceAndCity] SET Province=N'北京市',City=N'房山区' WHERE [Pkey] = 9 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(9,N'北京市',N'房山区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 10)
UPDATE [TProvinceAndCity] SET Province=N'北京市',City=N'通州区' WHERE [Pkey] = 10 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(10,N'北京市',N'通州区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 11)
UPDATE [TProvinceAndCity] SET Province=N'北京市',City=N'顺义区' WHERE [Pkey] = 11 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(11,N'北京市',N'顺义区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 12)
UPDATE [TProvinceAndCity] SET Province=N'北京市',City=N'昌平区' WHERE [Pkey] = 12 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(12,N'北京市',N'昌平区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 13)
UPDATE [TProvinceAndCity] SET Province=N'北京市',City=N'大兴区' WHERE [Pkey] = 13 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(13,N'北京市',N'大兴区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 14)
UPDATE [TProvinceAndCity] SET Province=N'北京市',City=N'怀柔区' WHERE [Pkey] = 14 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(14,N'北京市',N'怀柔区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 15)
UPDATE [TProvinceAndCity] SET Province=N'北京市',City=N'平谷区' WHERE [Pkey] = 15 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(15,N'北京市',N'平谷区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 16)
UPDATE [TProvinceAndCity] SET Province=N'北京市',City=N'密云县' WHERE [Pkey] = 16 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(16,N'北京市',N'密云县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 17)
UPDATE [TProvinceAndCity] SET Province=N'北京市',City=N'延庆县' WHERE [Pkey] = 17 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(17,N'北京市',N'延庆县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 18)
UPDATE [TProvinceAndCity] SET Province=N'上海市',City=N'黄浦区' WHERE [Pkey] = 18 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(18,N'上海市',N'黄浦区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 19)
UPDATE [TProvinceAndCity] SET Province=N'上海市',City=N'卢湾区' WHERE [Pkey] = 19 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(19,N'上海市',N'卢湾区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 20)
UPDATE [TProvinceAndCity] SET Province=N'上海市',City=N'徐汇区' WHERE [Pkey] = 20 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(20,N'上海市',N'徐汇区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 21)
UPDATE [TProvinceAndCity] SET Province=N'上海市',City=N'长宁区' WHERE [Pkey] = 21 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(21,N'上海市',N'长宁区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 22)
UPDATE [TProvinceAndCity] SET Province=N'上海市',City=N'静安区' WHERE [Pkey] = 22 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(22,N'上海市',N'静安区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 23)
UPDATE [TProvinceAndCity] SET Province=N'上海市',City=N'普陀区' WHERE [Pkey] = 23 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(23,N'上海市',N'普陀区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 24)
UPDATE [TProvinceAndCity] SET Province=N'上海市',City=N'闸北区' WHERE [Pkey] = 24 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(24,N'上海市',N'闸北区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 25)
UPDATE [TProvinceAndCity] SET Province=N'上海市',City=N'虹口区' WHERE [Pkey] = 25 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(25,N'上海市',N'虹口区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 26)
UPDATE [TProvinceAndCity] SET Province=N'上海市',City=N'杨浦区' WHERE [Pkey] = 26 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(26,N'上海市',N'杨浦区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 27)
UPDATE [TProvinceAndCity] SET Province=N'上海市',City=N'闵行区' WHERE [Pkey] = 27 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(27,N'上海市',N'闵行区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 28)
UPDATE [TProvinceAndCity] SET Province=N'上海市',City=N'宝山区' WHERE [Pkey] = 28 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(28,N'上海市',N'宝山区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 29)
UPDATE [TProvinceAndCity] SET Province=N'上海市',City=N'嘉定区' WHERE [Pkey] = 29 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(29,N'上海市',N'嘉定区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 30)
UPDATE [TProvinceAndCity] SET Province=N'上海市',City=N'浦东新区' WHERE [Pkey] = 30 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(30,N'上海市',N'浦东新区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 31)
UPDATE [TProvinceAndCity] SET Province=N'上海市',City=N'金山区' WHERE [Pkey] = 31 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(31,N'上海市',N'金山区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 32)
UPDATE [TProvinceAndCity] SET Province=N'上海市',City=N'松江区' WHERE [Pkey] = 32 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(32,N'上海市',N'松江区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 33)
UPDATE [TProvinceAndCity] SET Province=N'上海市',City=N'青浦区' WHERE [Pkey] = 33 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(33,N'上海市',N'青浦区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 34)
UPDATE [TProvinceAndCity] SET Province=N'上海市',City=N'南汇区' WHERE [Pkey] = 34 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(34,N'上海市',N'南汇区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 35)
UPDATE [TProvinceAndCity] SET Province=N'上海市',City=N'奉贤区' WHERE [Pkey] = 35 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(35,N'上海市',N'奉贤区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 36)
UPDATE [TProvinceAndCity] SET Province=N'上海市',City=N'崇明县' WHERE [Pkey] = 36 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(36,N'上海市',N'崇明县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 37)
UPDATE [TProvinceAndCity] SET Province=N'天津市',City=N'和平区' WHERE [Pkey] = 37 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(37,N'天津市',N'和平区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 38)
UPDATE [TProvinceAndCity] SET Province=N'天津市',City=N'河东区' WHERE [Pkey] = 38 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(38,N'天津市',N'河东区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 39)
UPDATE [TProvinceAndCity] SET Province=N'天津市',City=N'河西区' WHERE [Pkey] = 39 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(39,N'天津市',N'河西区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 40)
UPDATE [TProvinceAndCity] SET Province=N'天津市',City=N'南开区' WHERE [Pkey] = 40 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(40,N'天津市',N'南开区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 41)
UPDATE [TProvinceAndCity] SET Province=N'天津市',City=N'河北区' WHERE [Pkey] = 41 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(41,N'天津市',N'河北区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 42)
UPDATE [TProvinceAndCity] SET Province=N'天津市',City=N'红桥区' WHERE [Pkey] = 42 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(42,N'天津市',N'红桥区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 43)
UPDATE [TProvinceAndCity] SET Province=N'天津市',City=N'塘沽区' WHERE [Pkey] = 43 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(43,N'天津市',N'塘沽区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 44)
UPDATE [TProvinceAndCity] SET Province=N'天津市',City=N'汉沽区' WHERE [Pkey] = 44 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(44,N'天津市',N'汉沽区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 45)
UPDATE [TProvinceAndCity] SET Province=N'天津市',City=N'大港区' WHERE [Pkey] = 45 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(45,N'天津市',N'大港区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 46)
UPDATE [TProvinceAndCity] SET Province=N'天津市',City=N'东丽区' WHERE [Pkey] = 46 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(46,N'天津市',N'东丽区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 47)
UPDATE [TProvinceAndCity] SET Province=N'天津市',City=N'西青区' WHERE [Pkey] = 47 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(47,N'天津市',N'西青区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 48)
UPDATE [TProvinceAndCity] SET Province=N'天津市',City=N'津南区' WHERE [Pkey] = 48 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(48,N'天津市',N'津南区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 49)
UPDATE [TProvinceAndCity] SET Province=N'天津市',City=N'北辰区' WHERE [Pkey] = 49 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(49,N'天津市',N'北辰区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 50)
UPDATE [TProvinceAndCity] SET Province=N'天津市',City=N'武清区' WHERE [Pkey] = 50 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(50,N'天津市',N'武清区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 51)
UPDATE [TProvinceAndCity] SET Province=N'天津市',City=N'宝坻区' WHERE [Pkey] = 51 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(51,N'天津市',N'宝坻区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 52)
UPDATE [TProvinceAndCity] SET Province=N'天津市',City=N'宁河县' WHERE [Pkey] = 52 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(52,N'天津市',N'宁河县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 53)
UPDATE [TProvinceAndCity] SET Province=N'天津市',City=N'静海县' WHERE [Pkey] = 53 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(53,N'天津市',N'静海县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 54)
UPDATE [TProvinceAndCity] SET Province=N'天津市',City=N'蓟县' WHERE [Pkey] = 54 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(54,N'天津市',N'蓟县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 55)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'万州区' WHERE [Pkey] = 55 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(55,N'重庆市',N'万州区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 56)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'涪陵区' WHERE [Pkey] = 56 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(56,N'重庆市',N'涪陵区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 57)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'渝中区' WHERE [Pkey] = 57 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(57,N'重庆市',N'渝中区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 58)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'大渡口区' WHERE [Pkey] = 58 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(58,N'重庆市',N'大渡口区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 59)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'江北区' WHERE [Pkey] = 59 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(59,N'重庆市',N'江北区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 60)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'沙坪坝区' WHERE [Pkey] = 60 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(60,N'重庆市',N'沙坪坝区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 61)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'九龙坡区' WHERE [Pkey] = 61 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(61,N'重庆市',N'九龙坡区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 62)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'南岸区' WHERE [Pkey] = 62 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(62,N'重庆市',N'南岸区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 63)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'北碚区' WHERE [Pkey] = 63 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(63,N'重庆市',N'北碚区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 64)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'万盛区' WHERE [Pkey] = 64 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(64,N'重庆市',N'万盛区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 65)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'双桥区' WHERE [Pkey] = 65 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(65,N'重庆市',N'双桥区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 66)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'渝北区' WHERE [Pkey] = 66 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(66,N'重庆市',N'渝北区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 67)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'巴南区' WHERE [Pkey] = 67 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(67,N'重庆市',N'巴南区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 68)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'黔江区' WHERE [Pkey] = 68 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(68,N'重庆市',N'黔江区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 69)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'长寿区' WHERE [Pkey] = 69 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(69,N'重庆市',N'长寿区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 70)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'江津区' WHERE [Pkey] = 70 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(70,N'重庆市',N'江津区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 71)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'合川区' WHERE [Pkey] = 71 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(71,N'重庆市',N'合川区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 72)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'永川区' WHERE [Pkey] = 72 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(72,N'重庆市',N'永川区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 73)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'南川区' WHERE [Pkey] = 73 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(73,N'重庆市',N'南川区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 74)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'綦江县' WHERE [Pkey] = 74 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(74,N'重庆市',N'綦江县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 75)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'潼南县' WHERE [Pkey] = 75 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(75,N'重庆市',N'潼南县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 76)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'铜梁县' WHERE [Pkey] = 76 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(76,N'重庆市',N'铜梁县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 77)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'大足县' WHERE [Pkey] = 77 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(77,N'重庆市',N'大足县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 78)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'荣昌县' WHERE [Pkey] = 78 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(78,N'重庆市',N'荣昌县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 79)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'璧山县' WHERE [Pkey] = 79 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(79,N'重庆市',N'璧山县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 80)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'梁平县' WHERE [Pkey] = 80 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(80,N'重庆市',N'梁平县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 81)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'城口县' WHERE [Pkey] = 81 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(81,N'重庆市',N'城口县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 82)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'丰都县' WHERE [Pkey] = 82 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(82,N'重庆市',N'丰都县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 83)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'垫江县' WHERE [Pkey] = 83 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(83,N'重庆市',N'垫江县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 84)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'武隆县' WHERE [Pkey] = 84 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(84,N'重庆市',N'武隆县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 85)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'忠县' WHERE [Pkey] = 85 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(85,N'重庆市',N'忠县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 86)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'开县' WHERE [Pkey] = 86 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(86,N'重庆市',N'开县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 87)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'云阳县' WHERE [Pkey] = 87 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(87,N'重庆市',N'云阳县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 88)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'奉节县' WHERE [Pkey] = 88 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(88,N'重庆市',N'奉节县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 89)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'巫山县' WHERE [Pkey] = 89 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(89,N'重庆市',N'巫山县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 90)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'巫溪县' WHERE [Pkey] = 90 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(90,N'重庆市',N'巫溪县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 91)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'石柱土家族自治县' WHERE [Pkey] = 91 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(91,N'重庆市',N'石柱土家族自治县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 92)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'秀山土家族苗族自治县' WHERE [Pkey] = 92 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(92,N'重庆市',N'秀山土家族苗族自治县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 93)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'酉阳土家族苗族自治县' WHERE [Pkey] = 93 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(93,N'重庆市',N'酉阳土家族苗族自治县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 94)
UPDATE [TProvinceAndCity] SET Province=N'重庆市',City=N'彭水苗族土家族自治县' WHERE [Pkey] = 94 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(94,N'重庆市',N'彭水苗族土家族自治县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 95)
UPDATE [TProvinceAndCity] SET Province=N'黑龙江省',City=N'哈尔滨市' WHERE [Pkey] = 95 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(95,N'黑龙江省',N'哈尔滨市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 96)
UPDATE [TProvinceAndCity] SET Province=N'黑龙江省',City=N'齐齐哈尔市' WHERE [Pkey] = 96 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(96,N'黑龙江省',N'齐齐哈尔市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 97)
UPDATE [TProvinceAndCity] SET Province=N'黑龙江省',City=N'鸡西市' WHERE [Pkey] = 97 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(97,N'黑龙江省',N'鸡西市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 98)
UPDATE [TProvinceAndCity] SET Province=N'黑龙江省',City=N'鹤岗市' WHERE [Pkey] = 98 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(98,N'黑龙江省',N'鹤岗市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 99)
UPDATE [TProvinceAndCity] SET Province=N'黑龙江省',City=N'双鸭山市' WHERE [Pkey] = 99 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(99,N'黑龙江省',N'双鸭山市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 100)
UPDATE [TProvinceAndCity] SET Province=N'黑龙江省',City=N'大庆市' WHERE [Pkey] = 100 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(100,N'黑龙江省',N'大庆市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 101)
UPDATE [TProvinceAndCity] SET Province=N'黑龙江省',City=N'伊春市' WHERE [Pkey] = 101 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(101,N'黑龙江省',N'伊春市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 102)
UPDATE [TProvinceAndCity] SET Province=N'黑龙江省',City=N'佳木斯市' WHERE [Pkey] = 102 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(102,N'黑龙江省',N'佳木斯市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 103)
UPDATE [TProvinceAndCity] SET Province=N'黑龙江省',City=N'七台河市' WHERE [Pkey] = 103 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(103,N'黑龙江省',N'七台河市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 104)
UPDATE [TProvinceAndCity] SET Province=N'黑龙江省',City=N'牡丹江市' WHERE [Pkey] = 104 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(104,N'黑龙江省',N'牡丹江市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 105)
UPDATE [TProvinceAndCity] SET Province=N'黑龙江省',City=N'黑河市' WHERE [Pkey] = 105 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(105,N'黑龙江省',N'黑河市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 106)
UPDATE [TProvinceAndCity] SET Province=N'黑龙江省',City=N'绥化市' WHERE [Pkey] = 106 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(106,N'黑龙江省',N'绥化市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 107)
UPDATE [TProvinceAndCity] SET Province=N'黑龙江省',City=N'大兴安岭地区' WHERE [Pkey] = 107 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(107,N'黑龙江省',N'大兴安岭地区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 108)
UPDATE [TProvinceAndCity] SET Province=N'吉林省',City=N'长春市' WHERE [Pkey] = 108 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(108,N'吉林省',N'长春市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 109)
UPDATE [TProvinceAndCity] SET Province=N'吉林省',City=N'吉林市' WHERE [Pkey] = 109 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(109,N'吉林省',N'吉林市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 110)
UPDATE [TProvinceAndCity] SET Province=N'吉林省',City=N'四平市' WHERE [Pkey] = 110 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(110,N'吉林省',N'四平市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 111)
UPDATE [TProvinceAndCity] SET Province=N'吉林省',City=N'辽源市' WHERE [Pkey] = 111 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(111,N'吉林省',N'辽源市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 112)
UPDATE [TProvinceAndCity] SET Province=N'吉林省',City=N'通化市' WHERE [Pkey] = 112 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(112,N'吉林省',N'通化市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 113)
UPDATE [TProvinceAndCity] SET Province=N'吉林省',City=N'白山市' WHERE [Pkey] = 113 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(113,N'吉林省',N'白山市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 114)
UPDATE [TProvinceAndCity] SET Province=N'吉林省',City=N'松原市' WHERE [Pkey] = 114 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(114,N'吉林省',N'松原市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 115)
UPDATE [TProvinceAndCity] SET Province=N'吉林省',City=N'白城市' WHERE [Pkey] = 115 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(115,N'吉林省',N'白城市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 116)
UPDATE [TProvinceAndCity] SET Province=N'吉林省',City=N'延边朝鲜族自治州' WHERE [Pkey] = 116 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(116,N'吉林省',N'延边朝鲜族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 117)
UPDATE [TProvinceAndCity] SET Province=N'辽宁省',City=N'沈阳市' WHERE [Pkey] = 117 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(117,N'辽宁省',N'沈阳市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 118)
UPDATE [TProvinceAndCity] SET Province=N'辽宁省',City=N'大连市' WHERE [Pkey] = 118 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(118,N'辽宁省',N'大连市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 119)
UPDATE [TProvinceAndCity] SET Province=N'辽宁省',City=N'鞍山市' WHERE [Pkey] = 119 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(119,N'辽宁省',N'鞍山市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 120)
UPDATE [TProvinceAndCity] SET Province=N'辽宁省',City=N'抚顺市' WHERE [Pkey] = 120 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(120,N'辽宁省',N'抚顺市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 121)
UPDATE [TProvinceAndCity] SET Province=N'辽宁省',City=N'本溪市' WHERE [Pkey] = 121 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(121,N'辽宁省',N'本溪市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 122)
UPDATE [TProvinceAndCity] SET Province=N'辽宁省',City=N'丹东市' WHERE [Pkey] = 122 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(122,N'辽宁省',N'丹东市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 123)
UPDATE [TProvinceAndCity] SET Province=N'辽宁省',City=N'锦州市' WHERE [Pkey] = 123 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(123,N'辽宁省',N'锦州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 124)
UPDATE [TProvinceAndCity] SET Province=N'辽宁省',City=N'营口市' WHERE [Pkey] = 124 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(124,N'辽宁省',N'营口市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 125)
UPDATE [TProvinceAndCity] SET Province=N'辽宁省',City=N'阜新市' WHERE [Pkey] = 125 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(125,N'辽宁省',N'阜新市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 126)
UPDATE [TProvinceAndCity] SET Province=N'辽宁省',City=N'辽阳市' WHERE [Pkey] = 126 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(126,N'辽宁省',N'辽阳市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 127)
UPDATE [TProvinceAndCity] SET Province=N'辽宁省',City=N'盘锦市' WHERE [Pkey] = 127 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(127,N'辽宁省',N'盘锦市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 128)
UPDATE [TProvinceAndCity] SET Province=N'辽宁省',City=N'铁岭市' WHERE [Pkey] = 128 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(128,N'辽宁省',N'铁岭市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 129)
UPDATE [TProvinceAndCity] SET Province=N'辽宁省',City=N'朝阳市' WHERE [Pkey] = 129 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(129,N'辽宁省',N'朝阳市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 130)
UPDATE [TProvinceAndCity] SET Province=N'辽宁省',City=N'葫芦岛市' WHERE [Pkey] = 130 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(130,N'辽宁省',N'葫芦岛市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 131)
UPDATE [TProvinceAndCity] SET Province=N'山东省',City=N'济南市' WHERE [Pkey] = 131 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(131,N'山东省',N'济南市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 132)
UPDATE [TProvinceAndCity] SET Province=N'山东省',City=N'青岛市' WHERE [Pkey] = 132 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(132,N'山东省',N'青岛市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 133)
UPDATE [TProvinceAndCity] SET Province=N'山东省',City=N'淄博市' WHERE [Pkey] = 133 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(133,N'山东省',N'淄博市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 134)
UPDATE [TProvinceAndCity] SET Province=N'山东省',City=N'枣庄市' WHERE [Pkey] = 134 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(134,N'山东省',N'枣庄市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 135)
UPDATE [TProvinceAndCity] SET Province=N'山东省',City=N'东营市' WHERE [Pkey] = 135 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(135,N'山东省',N'东营市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 136)
UPDATE [TProvinceAndCity] SET Province=N'山东省',City=N'烟台市' WHERE [Pkey] = 136 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(136,N'山东省',N'烟台市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 137)
UPDATE [TProvinceAndCity] SET Province=N'山东省',City=N'潍坊市' WHERE [Pkey] = 137 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(137,N'山东省',N'潍坊市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 138)
UPDATE [TProvinceAndCity] SET Province=N'山东省',City=N'济宁市' WHERE [Pkey] = 138 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(138,N'山东省',N'济宁市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 139)
UPDATE [TProvinceAndCity] SET Province=N'山东省',City=N'泰安市' WHERE [Pkey] = 139 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(139,N'山东省',N'泰安市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 140)
UPDATE [TProvinceAndCity] SET Province=N'山东省',City=N'威海市' WHERE [Pkey] = 140 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(140,N'山东省',N'威海市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 141)
UPDATE [TProvinceAndCity] SET Province=N'山东省',City=N'日照市' WHERE [Pkey] = 141 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(141,N'山东省',N'日照市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 142)
UPDATE [TProvinceAndCity] SET Province=N'山东省',City=N'莱芜市' WHERE [Pkey] = 142 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(142,N'山东省',N'莱芜市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 143)
UPDATE [TProvinceAndCity] SET Province=N'山东省',City=N'临沂市' WHERE [Pkey] = 143 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(143,N'山东省',N'临沂市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 144)
UPDATE [TProvinceAndCity] SET Province=N'山东省',City=N'德州市' WHERE [Pkey] = 144 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(144,N'山东省',N'德州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 145)
UPDATE [TProvinceAndCity] SET Province=N'山东省',City=N'聊城市' WHERE [Pkey] = 145 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(145,N'山东省',N'聊城市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 146)
UPDATE [TProvinceAndCity] SET Province=N'山东省',City=N'滨州市' WHERE [Pkey] = 146 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(146,N'山东省',N'滨州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 147)
UPDATE [TProvinceAndCity] SET Province=N'山东省',City=N'菏泽市' WHERE [Pkey] = 147 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(147,N'山东省',N'菏泽市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 148)
UPDATE [TProvinceAndCity] SET Province=N'山西省',City=N'太原市' WHERE [Pkey] = 148 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(148,N'山西省',N'太原市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 149)
UPDATE [TProvinceAndCity] SET Province=N'山西省',City=N'大同市' WHERE [Pkey] = 149 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(149,N'山西省',N'大同市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 150)
UPDATE [TProvinceAndCity] SET Province=N'山西省',City=N'阳泉市' WHERE [Pkey] = 150 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(150,N'山西省',N'阳泉市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 151)
UPDATE [TProvinceAndCity] SET Province=N'山西省',City=N'长治市' WHERE [Pkey] = 151 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(151,N'山西省',N'长治市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 152)
UPDATE [TProvinceAndCity] SET Province=N'山西省',City=N'晋城市' WHERE [Pkey] = 152 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(152,N'山西省',N'晋城市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 153)
UPDATE [TProvinceAndCity] SET Province=N'山西省',City=N'朔州市' WHERE [Pkey] = 153 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(153,N'山西省',N'朔州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 154)
UPDATE [TProvinceAndCity] SET Province=N'山西省',City=N'晋中市' WHERE [Pkey] = 154 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(154,N'山西省',N'晋中市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 155)
UPDATE [TProvinceAndCity] SET Province=N'山西省',City=N'运城市' WHERE [Pkey] = 155 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(155,N'山西省',N'运城市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 156)
UPDATE [TProvinceAndCity] SET Province=N'山西省',City=N'忻州市' WHERE [Pkey] = 156 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(156,N'山西省',N'忻州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 157)
UPDATE [TProvinceAndCity] SET Province=N'山西省',City=N'临汾市' WHERE [Pkey] = 157 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(157,N'山西省',N'临汾市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 158)
UPDATE [TProvinceAndCity] SET Province=N'山西省',City=N'吕梁市' WHERE [Pkey] = 158 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(158,N'山西省',N'吕梁市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 159)
UPDATE [TProvinceAndCity] SET Province=N'陕西省',City=N'西安市' WHERE [Pkey] = 159 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(159,N'陕西省',N'西安市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 160)
UPDATE [TProvinceAndCity] SET Province=N'陕西省',City=N'铜川市' WHERE [Pkey] = 160 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(160,N'陕西省',N'铜川市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 161)
UPDATE [TProvinceAndCity] SET Province=N'陕西省',City=N'宝鸡市' WHERE [Pkey] = 161 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(161,N'陕西省',N'宝鸡市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 162)
UPDATE [TProvinceAndCity] SET Province=N'陕西省',City=N'咸阳市' WHERE [Pkey] = 162 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(162,N'陕西省',N'咸阳市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 163)
UPDATE [TProvinceAndCity] SET Province=N'陕西省',City=N'渭南市' WHERE [Pkey] = 163 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(163,N'陕西省',N'渭南市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 164)
UPDATE [TProvinceAndCity] SET Province=N'陕西省',City=N'延安市' WHERE [Pkey] = 164 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(164,N'陕西省',N'延安市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 165)
UPDATE [TProvinceAndCity] SET Province=N'陕西省',City=N'汉中市' WHERE [Pkey] = 165 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(165,N'陕西省',N'汉中市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 166)
UPDATE [TProvinceAndCity] SET Province=N'陕西省',City=N'榆林市' WHERE [Pkey] = 166 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(166,N'陕西省',N'榆林市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 167)
UPDATE [TProvinceAndCity] SET Province=N'陕西省',City=N'安康市' WHERE [Pkey] = 167 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(167,N'陕西省',N'安康市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 168)
UPDATE [TProvinceAndCity] SET Province=N'陕西省',City=N'商洛市' WHERE [Pkey] = 168 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(168,N'陕西省',N'商洛市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 169)
UPDATE [TProvinceAndCity] SET Province=N'河北省',City=N'石家庄市' WHERE [Pkey] = 169 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(169,N'河北省',N'石家庄市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 170)
UPDATE [TProvinceAndCity] SET Province=N'河北省',City=N'唐山市' WHERE [Pkey] = 170 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(170,N'河北省',N'唐山市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 171)
UPDATE [TProvinceAndCity] SET Province=N'河北省',City=N'秦皇岛市' WHERE [Pkey] = 171 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(171,N'河北省',N'秦皇岛市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 172)
UPDATE [TProvinceAndCity] SET Province=N'河北省',City=N'邯郸市' WHERE [Pkey] = 172 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(172,N'河北省',N'邯郸市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 173)
UPDATE [TProvinceAndCity] SET Province=N'河北省',City=N'邢台市' WHERE [Pkey] = 173 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(173,N'河北省',N'邢台市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 174)
UPDATE [TProvinceAndCity] SET Province=N'河北省',City=N'保定市' WHERE [Pkey] = 174 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(174,N'河北省',N'保定市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 175)
UPDATE [TProvinceAndCity] SET Province=N'河北省',City=N'张家口市' WHERE [Pkey] = 175 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(175,N'河北省',N'张家口市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 176)
UPDATE [TProvinceAndCity] SET Province=N'河北省',City=N'承德市' WHERE [Pkey] = 176 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(176,N'河北省',N'承德市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 177)
UPDATE [TProvinceAndCity] SET Province=N'河北省',City=N'沧州市' WHERE [Pkey] = 177 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(177,N'河北省',N'沧州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 178)
UPDATE [TProvinceAndCity] SET Province=N'河北省',City=N'廊坊市' WHERE [Pkey] = 178 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(178,N'河北省',N'廊坊市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 179)
UPDATE [TProvinceAndCity] SET Province=N'河北省',City=N'衡水市' WHERE [Pkey] = 179 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(179,N'河北省',N'衡水市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 180)
UPDATE [TProvinceAndCity] SET Province=N'河南省',City=N'郑州市' WHERE [Pkey] = 180 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(180,N'河南省',N'郑州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 181)
UPDATE [TProvinceAndCity] SET Province=N'河南省',City=N'开封市' WHERE [Pkey] = 181 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(181,N'河南省',N'开封市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 182)
UPDATE [TProvinceAndCity] SET Province=N'河南省',City=N'洛阳市' WHERE [Pkey] = 182 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(182,N'河南省',N'洛阳市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 183)
UPDATE [TProvinceAndCity] SET Province=N'河南省',City=N'平顶山市' WHERE [Pkey] = 183 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(183,N'河南省',N'平顶山市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 184)
UPDATE [TProvinceAndCity] SET Province=N'河南省',City=N'安阳市' WHERE [Pkey] = 184 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(184,N'河南省',N'安阳市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 185)
UPDATE [TProvinceAndCity] SET Province=N'河南省',City=N'鹤壁市' WHERE [Pkey] = 185 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(185,N'河南省',N'鹤壁市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 186)
UPDATE [TProvinceAndCity] SET Province=N'河南省',City=N'新乡市' WHERE [Pkey] = 186 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(186,N'河南省',N'新乡市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 187)
UPDATE [TProvinceAndCity] SET Province=N'河南省',City=N'焦作市' WHERE [Pkey] = 187 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(187,N'河南省',N'焦作市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 188)
UPDATE [TProvinceAndCity] SET Province=N'河南省',City=N'济源市' WHERE [Pkey] = 188 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(188,N'河南省',N'济源市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 189)
UPDATE [TProvinceAndCity] SET Province=N'河南省',City=N'濮阳市' WHERE [Pkey] = 189 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(189,N'河南省',N'濮阳市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 190)
UPDATE [TProvinceAndCity] SET Province=N'河南省',City=N'许昌市' WHERE [Pkey] = 190 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(190,N'河南省',N'许昌市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 191)
UPDATE [TProvinceAndCity] SET Province=N'河南省',City=N'漯河市' WHERE [Pkey] = 191 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(191,N'河南省',N'漯河市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 192)
UPDATE [TProvinceAndCity] SET Province=N'河南省',City=N'三门峡市' WHERE [Pkey] = 192 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(192,N'河南省',N'三门峡市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 193)
UPDATE [TProvinceAndCity] SET Province=N'河南省',City=N'南阳市' WHERE [Pkey] = 193 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(193,N'河南省',N'南阳市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 194)
UPDATE [TProvinceAndCity] SET Province=N'河南省',City=N'商丘市' WHERE [Pkey] = 194 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(194,N'河南省',N'商丘市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 195)
UPDATE [TProvinceAndCity] SET Province=N'河南省',City=N'信阳市' WHERE [Pkey] = 195 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(195,N'河南省',N'信阳市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 196)
UPDATE [TProvinceAndCity] SET Province=N'河南省',City=N'周口市' WHERE [Pkey] = 196 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(196,N'河南省',N'周口市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 197)
UPDATE [TProvinceAndCity] SET Province=N'河南省',City=N'驻马店市' WHERE [Pkey] = 197 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(197,N'河南省',N'驻马店市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 198)
UPDATE [TProvinceAndCity] SET Province=N'湖北省',City=N'武汉市' WHERE [Pkey] = 198 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(198,N'湖北省',N'武汉市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 199)
UPDATE [TProvinceAndCity] SET Province=N'湖北省',City=N'黄石市' WHERE [Pkey] = 199 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(199,N'湖北省',N'黄石市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 200)
UPDATE [TProvinceAndCity] SET Province=N'湖北省',City=N'十堰市' WHERE [Pkey] = 200 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(200,N'湖北省',N'十堰市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 201)
UPDATE [TProvinceAndCity] SET Province=N'湖北省',City=N'宜昌市' WHERE [Pkey] = 201 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(201,N'湖北省',N'宜昌市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 202)
UPDATE [TProvinceAndCity] SET Province=N'湖北省',City=N'襄樊市' WHERE [Pkey] = 202 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(202,N'湖北省',N'襄樊市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 203)
UPDATE [TProvinceAndCity] SET Province=N'湖北省',City=N'鄂州市' WHERE [Pkey] = 203 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(203,N'湖北省',N'鄂州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 204)
UPDATE [TProvinceAndCity] SET Province=N'湖北省',City=N'荆门市' WHERE [Pkey] = 204 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(204,N'湖北省',N'荆门市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 205)
UPDATE [TProvinceAndCity] SET Province=N'湖北省',City=N'孝感市' WHERE [Pkey] = 205 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(205,N'湖北省',N'孝感市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 206)
UPDATE [TProvinceAndCity] SET Province=N'湖北省',City=N'荆州市' WHERE [Pkey] = 206 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(206,N'湖北省',N'荆州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 207)
UPDATE [TProvinceAndCity] SET Province=N'湖北省',City=N'黄冈市' WHERE [Pkey] = 207 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(207,N'湖北省',N'黄冈市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 208)
UPDATE [TProvinceAndCity] SET Province=N'湖北省',City=N'咸宁市' WHERE [Pkey] = 208 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(208,N'湖北省',N'咸宁市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 209)
UPDATE [TProvinceAndCity] SET Province=N'湖北省',City=N'随州市' WHERE [Pkey] = 209 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(209,N'湖北省',N'随州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 210)
UPDATE [TProvinceAndCity] SET Province=N'湖北省',City=N'恩施土家族苗族自治州' WHERE [Pkey] = 210 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(210,N'湖北省',N'恩施土家族苗族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 211)
UPDATE [TProvinceAndCity] SET Province=N'湖北省',City=N'仙桃市' WHERE [Pkey] = 211 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(211,N'湖北省',N'仙桃市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 212)
UPDATE [TProvinceAndCity] SET Province=N'湖北省',City=N'潜江市' WHERE [Pkey] = 212 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(212,N'湖北省',N'潜江市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 213)
UPDATE [TProvinceAndCity] SET Province=N'湖北省',City=N'天门市' WHERE [Pkey] = 213 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(213,N'湖北省',N'天门市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 214)
UPDATE [TProvinceAndCity] SET Province=N'湖北省',City=N'神农架林区' WHERE [Pkey] = 214 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(214,N'湖北省',N'神农架林区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 215)
UPDATE [TProvinceAndCity] SET Province=N'湖南省',City=N'长沙市' WHERE [Pkey] = 215 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(215,N'湖南省',N'长沙市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 216)
UPDATE [TProvinceAndCity] SET Province=N'湖南省',City=N'株洲市' WHERE [Pkey] = 216 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(216,N'湖南省',N'株洲市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 217)
UPDATE [TProvinceAndCity] SET Province=N'湖南省',City=N'湘潭市' WHERE [Pkey] = 217 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(217,N'湖南省',N'湘潭市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 218)
UPDATE [TProvinceAndCity] SET Province=N'湖南省',City=N'衡阳市' WHERE [Pkey] = 218 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(218,N'湖南省',N'衡阳市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 219)
UPDATE [TProvinceAndCity] SET Province=N'湖南省',City=N'邵阳市' WHERE [Pkey] = 219 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(219,N'湖南省',N'邵阳市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 220)
UPDATE [TProvinceAndCity] SET Province=N'湖南省',City=N'岳阳市' WHERE [Pkey] = 220 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(220,N'湖南省',N'岳阳市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 221)
UPDATE [TProvinceAndCity] SET Province=N'湖南省',City=N'常德市' WHERE [Pkey] = 221 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(221,N'湖南省',N'常德市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 222)
UPDATE [TProvinceAndCity] SET Province=N'湖南省',City=N'张家界市' WHERE [Pkey] = 222 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(222,N'湖南省',N'张家界市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 223)
UPDATE [TProvinceAndCity] SET Province=N'湖南省',City=N'益阳市' WHERE [Pkey] = 223 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(223,N'湖南省',N'益阳市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 224)
UPDATE [TProvinceAndCity] SET Province=N'湖南省',City=N'郴州市' WHERE [Pkey] = 224 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(224,N'湖南省',N'郴州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 225)
UPDATE [TProvinceAndCity] SET Province=N'湖南省',City=N'永州市' WHERE [Pkey] = 225 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(225,N'湖南省',N'永州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 226)
UPDATE [TProvinceAndCity] SET Province=N'湖南省',City=N'怀化市' WHERE [Pkey] = 226 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(226,N'湖南省',N'怀化市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 227)
UPDATE [TProvinceAndCity] SET Province=N'湖南省',City=N'娄底市' WHERE [Pkey] = 227 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(227,N'湖南省',N'娄底市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 228)
UPDATE [TProvinceAndCity] SET Province=N'湖南省',City=N'湘西土家族苗族自治州' WHERE [Pkey] = 228 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(228,N'湖南省',N'湘西土家族苗族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 229)
UPDATE [TProvinceAndCity] SET Province=N'海南省',City=N'海口市' WHERE [Pkey] = 229 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(229,N'海南省',N'海口市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 230)
UPDATE [TProvinceAndCity] SET Province=N'海南省',City=N'三亚市' WHERE [Pkey] = 230 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(230,N'海南省',N'三亚市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 231)
UPDATE [TProvinceAndCity] SET Province=N'海南省',City=N'五指山市' WHERE [Pkey] = 231 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(231,N'海南省',N'五指山市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 232)
UPDATE [TProvinceAndCity] SET Province=N'海南省',City=N'琼海市' WHERE [Pkey] = 232 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(232,N'海南省',N'琼海市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 233)
UPDATE [TProvinceAndCity] SET Province=N'海南省',City=N'儋州市' WHERE [Pkey] = 233 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(233,N'海南省',N'儋州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 234)
UPDATE [TProvinceAndCity] SET Province=N'海南省',City=N'文昌市' WHERE [Pkey] = 234 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(234,N'海南省',N'文昌市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 235)
UPDATE [TProvinceAndCity] SET Province=N'海南省',City=N'万宁市' WHERE [Pkey] = 235 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(235,N'海南省',N'万宁市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 236)
UPDATE [TProvinceAndCity] SET Province=N'海南省',City=N'东方市' WHERE [Pkey] = 236 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(236,N'海南省',N'东方市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 237)
UPDATE [TProvinceAndCity] SET Province=N'海南省',City=N'定安县' WHERE [Pkey] = 237 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(237,N'海南省',N'定安县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 238)
UPDATE [TProvinceAndCity] SET Province=N'海南省',City=N'屯昌县' WHERE [Pkey] = 238 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(238,N'海南省',N'屯昌县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 239)
UPDATE [TProvinceAndCity] SET Province=N'海南省',City=N'澄迈县' WHERE [Pkey] = 239 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(239,N'海南省',N'澄迈县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 240)
UPDATE [TProvinceAndCity] SET Province=N'海南省',City=N'临高县' WHERE [Pkey] = 240 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(240,N'海南省',N'临高县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 241)
UPDATE [TProvinceAndCity] SET Province=N'海南省',City=N'白沙黎族自治县' WHERE [Pkey] = 241 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(241,N'海南省',N'白沙黎族自治县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 242)
UPDATE [TProvinceAndCity] SET Province=N'海南省',City=N'昌江黎族自治县' WHERE [Pkey] = 242 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(242,N'海南省',N'昌江黎族自治县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 243)
UPDATE [TProvinceAndCity] SET Province=N'海南省',City=N'乐东黎族自治县' WHERE [Pkey] = 243 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(243,N'海南省',N'乐东黎族自治县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 244)
UPDATE [TProvinceAndCity] SET Province=N'海南省',City=N'陵水黎族自治县' WHERE [Pkey] = 244 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(244,N'海南省',N'陵水黎族自治县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 245)
UPDATE [TProvinceAndCity] SET Province=N'海南省',City=N'保亭黎族苗族自治县' WHERE [Pkey] = 245 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(245,N'海南省',N'保亭黎族苗族自治县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 246)
UPDATE [TProvinceAndCity] SET Province=N'海南省',City=N'琼中黎族苗族自治县' WHERE [Pkey] = 246 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(246,N'海南省',N'琼中黎族苗族自治县');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 247)
UPDATE [TProvinceAndCity] SET Province=N'江苏省',City=N'南京市' WHERE [Pkey] = 247 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(247,N'江苏省',N'南京市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 248)
UPDATE [TProvinceAndCity] SET Province=N'江苏省',City=N'无锡市' WHERE [Pkey] = 248 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(248,N'江苏省',N'无锡市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 249)
UPDATE [TProvinceAndCity] SET Province=N'江苏省',City=N'徐州市' WHERE [Pkey] = 249 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(249,N'江苏省',N'徐州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 250)
UPDATE [TProvinceAndCity] SET Province=N'江苏省',City=N'常州市' WHERE [Pkey] = 250 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(250,N'江苏省',N'常州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 251)
UPDATE [TProvinceAndCity] SET Province=N'江苏省',City=N'苏州市' WHERE [Pkey] = 251 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(251,N'江苏省',N'苏州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 252)
UPDATE [TProvinceAndCity] SET Province=N'江苏省',City=N'南通市' WHERE [Pkey] = 252 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(252,N'江苏省',N'南通市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 253)
UPDATE [TProvinceAndCity] SET Province=N'江苏省',City=N'连云港市' WHERE [Pkey] = 253 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(253,N'江苏省',N'连云港市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 254)
UPDATE [TProvinceAndCity] SET Province=N'江苏省',City=N'淮安市' WHERE [Pkey] = 254 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(254,N'江苏省',N'淮安市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 255)
UPDATE [TProvinceAndCity] SET Province=N'江苏省',City=N'盐城市' WHERE [Pkey] = 255 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(255,N'江苏省',N'盐城市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 256)
UPDATE [TProvinceAndCity] SET Province=N'江苏省',City=N'扬州市' WHERE [Pkey] = 256 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(256,N'江苏省',N'扬州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 257)
UPDATE [TProvinceAndCity] SET Province=N'江苏省',City=N'镇江市' WHERE [Pkey] = 257 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(257,N'江苏省',N'镇江市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 258)
UPDATE [TProvinceAndCity] SET Province=N'江苏省',City=N'泰州市' WHERE [Pkey] = 258 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(258,N'江苏省',N'泰州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 259)
UPDATE [TProvinceAndCity] SET Province=N'江苏省',City=N'宿迁市' WHERE [Pkey] = 259 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(259,N'江苏省',N'宿迁市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 260)
UPDATE [TProvinceAndCity] SET Province=N'江西省',City=N'南昌市' WHERE [Pkey] = 260 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(260,N'江西省',N'南昌市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 261)
UPDATE [TProvinceAndCity] SET Province=N'江西省',City=N'景德镇市' WHERE [Pkey] = 261 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(261,N'江西省',N'景德镇市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 262)
UPDATE [TProvinceAndCity] SET Province=N'江西省',City=N'萍乡市' WHERE [Pkey] = 262 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(262,N'江西省',N'萍乡市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 263)
UPDATE [TProvinceAndCity] SET Province=N'江西省',City=N'九江市' WHERE [Pkey] = 263 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(263,N'江西省',N'九江市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 264)
UPDATE [TProvinceAndCity] SET Province=N'江西省',City=N'新余市' WHERE [Pkey] = 264 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(264,N'江西省',N'新余市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 265)
UPDATE [TProvinceAndCity] SET Province=N'江西省',City=N'鹰潭市' WHERE [Pkey] = 265 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(265,N'江西省',N'鹰潭市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 266)
UPDATE [TProvinceAndCity] SET Province=N'江西省',City=N'赣州市' WHERE [Pkey] = 266 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(266,N'江西省',N'赣州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 267)
UPDATE [TProvinceAndCity] SET Province=N'江西省',City=N'吉安市' WHERE [Pkey] = 267 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(267,N'江西省',N'吉安市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 268)
UPDATE [TProvinceAndCity] SET Province=N'江西省',City=N'宜春市' WHERE [Pkey] = 268 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(268,N'江西省',N'宜春市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 269)
UPDATE [TProvinceAndCity] SET Province=N'江西省',City=N'抚州市' WHERE [Pkey] = 269 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(269,N'江西省',N'抚州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 270)
UPDATE [TProvinceAndCity] SET Province=N'江西省',City=N'上饶市' WHERE [Pkey] = 270 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(270,N'江西省',N'上饶市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 271)
UPDATE [TProvinceAndCity] SET Province=N'广东省',City=N'广州市' WHERE [Pkey] = 271 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(271,N'广东省',N'广州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 272)
UPDATE [TProvinceAndCity] SET Province=N'广东省',City=N'韶关市' WHERE [Pkey] = 272 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(272,N'广东省',N'韶关市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 273)
UPDATE [TProvinceAndCity] SET Province=N'广东省',City=N'深圳市' WHERE [Pkey] = 273 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(273,N'广东省',N'深圳市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 274)
UPDATE [TProvinceAndCity] SET Province=N'广东省',City=N'珠海市' WHERE [Pkey] = 274 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(274,N'广东省',N'珠海市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 275)
UPDATE [TProvinceAndCity] SET Province=N'广东省',City=N'汕头市' WHERE [Pkey] = 275 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(275,N'广东省',N'汕头市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 276)
UPDATE [TProvinceAndCity] SET Province=N'广东省',City=N'佛山市' WHERE [Pkey] = 276 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(276,N'广东省',N'佛山市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 277)
UPDATE [TProvinceAndCity] SET Province=N'广东省',City=N'江门市' WHERE [Pkey] = 277 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(277,N'广东省',N'江门市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 278)
UPDATE [TProvinceAndCity] SET Province=N'广东省',City=N'湛江市' WHERE [Pkey] = 278 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(278,N'广东省',N'湛江市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 279)
UPDATE [TProvinceAndCity] SET Province=N'广东省',City=N'茂名市' WHERE [Pkey] = 279 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(279,N'广东省',N'茂名市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 280)
UPDATE [TProvinceAndCity] SET Province=N'广东省',City=N'肇庆市' WHERE [Pkey] = 280 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(280,N'广东省',N'肇庆市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 281)
UPDATE [TProvinceAndCity] SET Province=N'广东省',City=N'惠州市' WHERE [Pkey] = 281 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(281,N'广东省',N'惠州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 282)
UPDATE [TProvinceAndCity] SET Province=N'广东省',City=N'梅州市' WHERE [Pkey] = 282 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(282,N'广东省',N'梅州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 283)
UPDATE [TProvinceAndCity] SET Province=N'广东省',City=N'汕尾市' WHERE [Pkey] = 283 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(283,N'广东省',N'汕尾市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 284)
UPDATE [TProvinceAndCity] SET Province=N'广东省',City=N'河源市' WHERE [Pkey] = 284 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(284,N'广东省',N'河源市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 285)
UPDATE [TProvinceAndCity] SET Province=N'广东省',City=N'阳江市' WHERE [Pkey] = 285 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(285,N'广东省',N'阳江市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 286)
UPDATE [TProvinceAndCity] SET Province=N'广东省',City=N'清远市' WHERE [Pkey] = 286 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(286,N'广东省',N'清远市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 287)
UPDATE [TProvinceAndCity] SET Province=N'广东省',City=N'东莞市' WHERE [Pkey] = 287 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(287,N'广东省',N'东莞市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 288)
UPDATE [TProvinceAndCity] SET Province=N'广东省',City=N'中山市' WHERE [Pkey] = 288 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(288,N'广东省',N'中山市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 289)
UPDATE [TProvinceAndCity] SET Province=N'广东省',City=N'潮州市' WHERE [Pkey] = 289 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(289,N'广东省',N'潮州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 290)
UPDATE [TProvinceAndCity] SET Province=N'广东省',City=N'揭阳市' WHERE [Pkey] = 290 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(290,N'广东省',N'揭阳市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 291)
UPDATE [TProvinceAndCity] SET Province=N'广东省',City=N'云浮市' WHERE [Pkey] = 291 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(291,N'广东省',N'云浮市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 292)
UPDATE [TProvinceAndCity] SET Province=N'广西省',City=N'南宁市' WHERE [Pkey] = 292 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(292,N'广西省',N'南宁市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 293)
UPDATE [TProvinceAndCity] SET Province=N'广西省',City=N'柳州市' WHERE [Pkey] = 293 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(293,N'广西省',N'柳州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 294)
UPDATE [TProvinceAndCity] SET Province=N'广西省',City=N'桂林市' WHERE [Pkey] = 294 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(294,N'广西省',N'桂林市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 295)
UPDATE [TProvinceAndCity] SET Province=N'广西省',City=N'梧州市' WHERE [Pkey] = 295 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(295,N'广西省',N'梧州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 296)
UPDATE [TProvinceAndCity] SET Province=N'广西省',City=N'北海市' WHERE [Pkey] = 296 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(296,N'广西省',N'北海市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 297)
UPDATE [TProvinceAndCity] SET Province=N'广西省',City=N'防城港市' WHERE [Pkey] = 297 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(297,N'广西省',N'防城港市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 298)
UPDATE [TProvinceAndCity] SET Province=N'广西省',City=N'钦州市' WHERE [Pkey] = 298 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(298,N'广西省',N'钦州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 299)
UPDATE [TProvinceAndCity] SET Province=N'广西省',City=N'贵港市' WHERE [Pkey] = 299 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(299,N'广西省',N'贵港市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 300)
UPDATE [TProvinceAndCity] SET Province=N'广西省',City=N'玉林市' WHERE [Pkey] = 300 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(300,N'广西省',N'玉林市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 301)
UPDATE [TProvinceAndCity] SET Province=N'广西省',City=N'百色市' WHERE [Pkey] = 301 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(301,N'广西省',N'百色市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 302)
UPDATE [TProvinceAndCity] SET Province=N'广西省',City=N'贺州市' WHERE [Pkey] = 302 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(302,N'广西省',N'贺州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 303)
UPDATE [TProvinceAndCity] SET Province=N'广西省',City=N'河池市' WHERE [Pkey] = 303 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(303,N'广西省',N'河池市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 304)
UPDATE [TProvinceAndCity] SET Province=N'广西省',City=N'来宾市' WHERE [Pkey] = 304 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(304,N'广西省',N'来宾市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 305)
UPDATE [TProvinceAndCity] SET Province=N'广西省',City=N'崇左市' WHERE [Pkey] = 305 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(305,N'广西省',N'崇左市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 306)
UPDATE [TProvinceAndCity] SET Province=N'云南省',City=N'昆明市' WHERE [Pkey] = 306 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(306,N'云南省',N'昆明市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 307)
UPDATE [TProvinceAndCity] SET Province=N'云南省',City=N'曲靖市' WHERE [Pkey] = 307 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(307,N'云南省',N'曲靖市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 308)
UPDATE [TProvinceAndCity] SET Province=N'云南省',City=N'玉溪市' WHERE [Pkey] = 308 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(308,N'云南省',N'玉溪市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 309)
UPDATE [TProvinceAndCity] SET Province=N'云南省',City=N'保山市' WHERE [Pkey] = 309 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(309,N'云南省',N'保山市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 310)
UPDATE [TProvinceAndCity] SET Province=N'云南省',City=N'昭通市' WHERE [Pkey] = 310 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(310,N'云南省',N'昭通市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 311)
UPDATE [TProvinceAndCity] SET Province=N'云南省',City=N'丽江市' WHERE [Pkey] = 311 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(311,N'云南省',N'丽江市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 312)
UPDATE [TProvinceAndCity] SET Province=N'云南省',City=N'思茅市' WHERE [Pkey] = 312 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(312,N'云南省',N'思茅市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 313)
UPDATE [TProvinceAndCity] SET Province=N'云南省',City=N'临沧市' WHERE [Pkey] = 313 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(313,N'云南省',N'临沧市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 314)
UPDATE [TProvinceAndCity] SET Province=N'云南省',City=N'楚雄彝族自治州' WHERE [Pkey] = 314 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(314,N'云南省',N'楚雄彝族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 315)
UPDATE [TProvinceAndCity] SET Province=N'云南省',City=N'红河哈尼族彝族自治州' WHERE [Pkey] = 315 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(315,N'云南省',N'红河哈尼族彝族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 316)
UPDATE [TProvinceAndCity] SET Province=N'云南省',City=N'文山壮族苗族自治州' WHERE [Pkey] = 316 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(316,N'云南省',N'文山壮族苗族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 317)
UPDATE [TProvinceAndCity] SET Province=N'云南省',City=N'西双版纳傣族自治州' WHERE [Pkey] = 317 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(317,N'云南省',N'西双版纳傣族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 318)
UPDATE [TProvinceAndCity] SET Province=N'云南省',City=N'大理白族自治州' WHERE [Pkey] = 318 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(318,N'云南省',N'大理白族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 319)
UPDATE [TProvinceAndCity] SET Province=N'云南省',City=N'德宏傣族景颇族自治州' WHERE [Pkey] = 319 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(319,N'云南省',N'德宏傣族景颇族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 320)
UPDATE [TProvinceAndCity] SET Province=N'云南省',City=N'怒江傈僳族自治州' WHERE [Pkey] = 320 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(320,N'云南省',N'怒江傈僳族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 321)
UPDATE [TProvinceAndCity] SET Province=N'云南省',City=N'迪庆藏族自治州' WHERE [Pkey] = 321 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(321,N'云南省',N'迪庆藏族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 322)
UPDATE [TProvinceAndCity] SET Province=N'贵州省',City=N'贵阳市' WHERE [Pkey] = 322 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(322,N'贵州省',N'贵阳市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 323)
UPDATE [TProvinceAndCity] SET Province=N'贵州省',City=N'六盘水市' WHERE [Pkey] = 323 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(323,N'贵州省',N'六盘水市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 324)
UPDATE [TProvinceAndCity] SET Province=N'贵州省',City=N'遵义市' WHERE [Pkey] = 324 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(324,N'贵州省',N'遵义市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 325)
UPDATE [TProvinceAndCity] SET Province=N'贵州省',City=N'安顺市' WHERE [Pkey] = 325 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(325,N'贵州省',N'安顺市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 326)
UPDATE [TProvinceAndCity] SET Province=N'贵州省',City=N'铜仁地区' WHERE [Pkey] = 326 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(326,N'贵州省',N'铜仁地区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 327)
UPDATE [TProvinceAndCity] SET Province=N'贵州省',City=N'黔西南布依族苗族自治州' WHERE [Pkey] = 327 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(327,N'贵州省',N'黔西南布依族苗族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 328)
UPDATE [TProvinceAndCity] SET Province=N'贵州省',City=N'毕节地区' WHERE [Pkey] = 328 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(328,N'贵州省',N'毕节地区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 329)
UPDATE [TProvinceAndCity] SET Province=N'贵州省',City=N'黔东南苗族侗族自治州' WHERE [Pkey] = 329 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(329,N'贵州省',N'黔东南苗族侗族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 330)
UPDATE [TProvinceAndCity] SET Province=N'贵州省',City=N'黔南布依族苗族自治州' WHERE [Pkey] = 330 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(330,N'贵州省',N'黔南布依族苗族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 331)
UPDATE [TProvinceAndCity] SET Province=N'四川省',City=N'成都市' WHERE [Pkey] = 331 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(331,N'四川省',N'成都市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 332)
UPDATE [TProvinceAndCity] SET Province=N'四川省',City=N'自贡市' WHERE [Pkey] = 332 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(332,N'四川省',N'自贡市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 333)
UPDATE [TProvinceAndCity] SET Province=N'四川省',City=N'攀枝花市' WHERE [Pkey] = 333 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(333,N'四川省',N'攀枝花市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 334)
UPDATE [TProvinceAndCity] SET Province=N'四川省',City=N'泸州市' WHERE [Pkey] = 334 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(334,N'四川省',N'泸州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 335)
UPDATE [TProvinceAndCity] SET Province=N'四川省',City=N'德阳市' WHERE [Pkey] = 335 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(335,N'四川省',N'德阳市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 336)
UPDATE [TProvinceAndCity] SET Province=N'四川省',City=N'绵阳市' WHERE [Pkey] = 336 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(336,N'四川省',N'绵阳市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 337)
UPDATE [TProvinceAndCity] SET Province=N'四川省',City=N'广元市' WHERE [Pkey] = 337 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(337,N'四川省',N'广元市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 338)
UPDATE [TProvinceAndCity] SET Province=N'四川省',City=N'遂宁市' WHERE [Pkey] = 338 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(338,N'四川省',N'遂宁市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 339)
UPDATE [TProvinceAndCity] SET Province=N'四川省',City=N'内江市' WHERE [Pkey] = 339 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(339,N'四川省',N'内江市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 340)
UPDATE [TProvinceAndCity] SET Province=N'四川省',City=N'乐山市' WHERE [Pkey] = 340 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(340,N'四川省',N'乐山市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 341)
UPDATE [TProvinceAndCity] SET Province=N'四川省',City=N'南充市' WHERE [Pkey] = 341 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(341,N'四川省',N'南充市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 342)
UPDATE [TProvinceAndCity] SET Province=N'四川省',City=N'眉山市' WHERE [Pkey] = 342 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(342,N'四川省',N'眉山市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 343)
UPDATE [TProvinceAndCity] SET Province=N'四川省',City=N'宜宾市' WHERE [Pkey] = 343 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(343,N'四川省',N'宜宾市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 344)
UPDATE [TProvinceAndCity] SET Province=N'四川省',City=N'广安市' WHERE [Pkey] = 344 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(344,N'四川省',N'广安市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 345)
UPDATE [TProvinceAndCity] SET Province=N'四川省',City=N'达州市' WHERE [Pkey] = 345 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(345,N'四川省',N'达州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 346)
UPDATE [TProvinceAndCity] SET Province=N'四川省',City=N'雅安市' WHERE [Pkey] = 346 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(346,N'四川省',N'雅安市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 347)
UPDATE [TProvinceAndCity] SET Province=N'四川省',City=N'巴中市' WHERE [Pkey] = 347 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(347,N'四川省',N'巴中市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 348)
UPDATE [TProvinceAndCity] SET Province=N'四川省',City=N'资阳市' WHERE [Pkey] = 348 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(348,N'四川省',N'资阳市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 349)
UPDATE [TProvinceAndCity] SET Province=N'四川省',City=N'阿坝藏族羌族自治州' WHERE [Pkey] = 349 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(349,N'四川省',N'阿坝藏族羌族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 350)
UPDATE [TProvinceAndCity] SET Province=N'四川省',City=N'甘孜藏族自治州' WHERE [Pkey] = 350 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(350,N'四川省',N'甘孜藏族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 351)
UPDATE [TProvinceAndCity] SET Province=N'四川省',City=N'凉山彝族自治州' WHERE [Pkey] = 351 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(351,N'四川省',N'凉山彝族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 352)
UPDATE [TProvinceAndCity] SET Province=N'内蒙古自治区',City=N'呼和浩特市' WHERE [Pkey] = 352 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(352,N'内蒙古自治区',N'呼和浩特市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 353)
UPDATE [TProvinceAndCity] SET Province=N'内蒙古自治区',City=N'包头市' WHERE [Pkey] = 353 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(353,N'内蒙古自治区',N'包头市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 354)
UPDATE [TProvinceAndCity] SET Province=N'内蒙古自治区',City=N'乌海市' WHERE [Pkey] = 354 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(354,N'内蒙古自治区',N'乌海市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 355)
UPDATE [TProvinceAndCity] SET Province=N'内蒙古自治区',City=N'赤峰市' WHERE [Pkey] = 355 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(355,N'内蒙古自治区',N'赤峰市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 356)
UPDATE [TProvinceAndCity] SET Province=N'内蒙古自治区',City=N'通辽市' WHERE [Pkey] = 356 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(356,N'内蒙古自治区',N'通辽市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 357)
UPDATE [TProvinceAndCity] SET Province=N'内蒙古自治区',City=N'鄂尔多斯市' WHERE [Pkey] = 357 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(357,N'内蒙古自治区',N'鄂尔多斯市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 358)
UPDATE [TProvinceAndCity] SET Province=N'内蒙古自治区',City=N'呼伦贝尔市' WHERE [Pkey] = 358 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(358,N'内蒙古自治区',N'呼伦贝尔市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 359)
UPDATE [TProvinceAndCity] SET Province=N'内蒙古自治区',City=N'巴彦淖尔市' WHERE [Pkey] = 359 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(359,N'内蒙古自治区',N'巴彦淖尔市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 360)
UPDATE [TProvinceAndCity] SET Province=N'内蒙古自治区',City=N'乌兰察布市' WHERE [Pkey] = 360 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(360,N'内蒙古自治区',N'乌兰察布市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 361)
UPDATE [TProvinceAndCity] SET Province=N'内蒙古自治区',City=N'兴安盟' WHERE [Pkey] = 361 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(361,N'内蒙古自治区',N'兴安盟');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 362)
UPDATE [TProvinceAndCity] SET Province=N'内蒙古自治区',City=N'锡林郭勒盟' WHERE [Pkey] = 362 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(362,N'内蒙古自治区',N'锡林郭勒盟');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 363)
UPDATE [TProvinceAndCity] SET Province=N'内蒙古自治区',City=N'阿拉善盟' WHERE [Pkey] = 363 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(363,N'内蒙古自治区',N'阿拉善盟');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 364)
UPDATE [TProvinceAndCity] SET Province=N'宁夏回族自治区',City=N'银川市' WHERE [Pkey] = 364 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(364,N'宁夏回族自治区',N'银川市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 365)
UPDATE [TProvinceAndCity] SET Province=N'宁夏回族自治区',City=N'石嘴山市' WHERE [Pkey] = 365 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(365,N'宁夏回族自治区',N'石嘴山市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 366)
UPDATE [TProvinceAndCity] SET Province=N'宁夏回族自治区',City=N'吴忠市' WHERE [Pkey] = 366 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(366,N'宁夏回族自治区',N'吴忠市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 367)
UPDATE [TProvinceAndCity] SET Province=N'宁夏回族自治区',City=N'固原市' WHERE [Pkey] = 367 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(367,N'宁夏回族自治区',N'固原市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 368)
UPDATE [TProvinceAndCity] SET Province=N'宁夏回族自治区',City=N'中卫市' WHERE [Pkey] = 368 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(368,N'宁夏回族自治区',N'中卫市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 369)
UPDATE [TProvinceAndCity] SET Province=N'甘肃省',City=N'兰州市' WHERE [Pkey] = 369 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(369,N'甘肃省',N'兰州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 370)
UPDATE [TProvinceAndCity] SET Province=N'甘肃省',City=N'嘉峪关市' WHERE [Pkey] = 370 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(370,N'甘肃省',N'嘉峪关市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 371)
UPDATE [TProvinceAndCity] SET Province=N'甘肃省',City=N'金昌市' WHERE [Pkey] = 371 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(371,N'甘肃省',N'金昌市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 372)
UPDATE [TProvinceAndCity] SET Province=N'甘肃省',City=N'白银市' WHERE [Pkey] = 372 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(372,N'甘肃省',N'白银市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 373)
UPDATE [TProvinceAndCity] SET Province=N'甘肃省',City=N'天水市' WHERE [Pkey] = 373 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(373,N'甘肃省',N'天水市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 374)
UPDATE [TProvinceAndCity] SET Province=N'甘肃省',City=N'武威市' WHERE [Pkey] = 374 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(374,N'甘肃省',N'武威市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 375)
UPDATE [TProvinceAndCity] SET Province=N'甘肃省',City=N'张掖市' WHERE [Pkey] = 375 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(375,N'甘肃省',N'张掖市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 376)
UPDATE [TProvinceAndCity] SET Province=N'甘肃省',City=N'平凉市' WHERE [Pkey] = 376 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(376,N'甘肃省',N'平凉市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 377)
UPDATE [TProvinceAndCity] SET Province=N'甘肃省',City=N'酒泉市' WHERE [Pkey] = 377 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(377,N'甘肃省',N'酒泉市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 378)
UPDATE [TProvinceAndCity] SET Province=N'甘肃省',City=N'庆阳市' WHERE [Pkey] = 378 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(378,N'甘肃省',N'庆阳市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 379)
UPDATE [TProvinceAndCity] SET Province=N'甘肃省',City=N'定西市' WHERE [Pkey] = 379 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(379,N'甘肃省',N'定西市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 380)
UPDATE [TProvinceAndCity] SET Province=N'甘肃省',City=N'陇南市' WHERE [Pkey] = 380 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(380,N'甘肃省',N'陇南市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 381)
UPDATE [TProvinceAndCity] SET Province=N'甘肃省',City=N'临夏回族自治州' WHERE [Pkey] = 381 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(381,N'甘肃省',N'临夏回族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 382)
UPDATE [TProvinceAndCity] SET Province=N'甘肃省',City=N'甘南藏族自治州' WHERE [Pkey] = 382 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(382,N'甘肃省',N'甘南藏族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 383)
UPDATE [TProvinceAndCity] SET Province=N'青海省',City=N'西宁市' WHERE [Pkey] = 383 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(383,N'青海省',N'西宁市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 384)
UPDATE [TProvinceAndCity] SET Province=N'青海省',City=N'海东地区' WHERE [Pkey] = 384 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(384,N'青海省',N'海东地区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 385)
UPDATE [TProvinceAndCity] SET Province=N'青海省',City=N'海北藏族自治州' WHERE [Pkey] = 385 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(385,N'青海省',N'海北藏族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 386)
UPDATE [TProvinceAndCity] SET Province=N'青海省',City=N'黄南藏族自治州' WHERE [Pkey] = 386 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(386,N'青海省',N'黄南藏族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 387)
UPDATE [TProvinceAndCity] SET Province=N'青海省',City=N'海南藏族自治州' WHERE [Pkey] = 387 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(387,N'青海省',N'海南藏族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 388)
UPDATE [TProvinceAndCity] SET Province=N'青海省',City=N'果洛藏族自治州' WHERE [Pkey] = 388 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(388,N'青海省',N'果洛藏族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 389)
UPDATE [TProvinceAndCity] SET Province=N'青海省',City=N'玉树藏族自治州' WHERE [Pkey] = 389 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(389,N'青海省',N'玉树藏族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 390)
UPDATE [TProvinceAndCity] SET Province=N'青海省',City=N'海西蒙古族藏族自治州' WHERE [Pkey] = 390 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(390,N'青海省',N'海西蒙古族藏族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 391)
UPDATE [TProvinceAndCity] SET Province=N'西藏自治区',City=N'拉萨市' WHERE [Pkey] = 391 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(391,N'西藏自治区',N'拉萨市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 392)
UPDATE [TProvinceAndCity] SET Province=N'西藏自治区',City=N'昌都地区' WHERE [Pkey] = 392 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(392,N'西藏自治区',N'昌都地区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 393)
UPDATE [TProvinceAndCity] SET Province=N'西藏自治区',City=N'山南地区' WHERE [Pkey] = 393 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(393,N'西藏自治区',N'山南地区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 394)
UPDATE [TProvinceAndCity] SET Province=N'西藏自治区',City=N'日喀则地区' WHERE [Pkey] = 394 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(394,N'西藏自治区',N'日喀则地区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 395)
UPDATE [TProvinceAndCity] SET Province=N'西藏自治区',City=N'那曲地区' WHERE [Pkey] = 395 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(395,N'西藏自治区',N'那曲地区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 396)
UPDATE [TProvinceAndCity] SET Province=N'西藏自治区',City=N'阿里地区' WHERE [Pkey] = 396 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(396,N'西藏自治区',N'阿里地区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 397)
UPDATE [TProvinceAndCity] SET Province=N'西藏自治区',City=N'林芝地区' WHERE [Pkey] = 397 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(397,N'西藏自治区',N'林芝地区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 398)
UPDATE [TProvinceAndCity] SET Province=N'新疆自治区',City=N'乌鲁木齐市' WHERE [Pkey] = 398 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(398,N'新疆自治区',N'乌鲁木齐市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 399)
UPDATE [TProvinceAndCity] SET Province=N'新疆自治区',City=N'克拉玛依市' WHERE [Pkey] = 399 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(399,N'新疆自治区',N'克拉玛依市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 400)
UPDATE [TProvinceAndCity] SET Province=N'新疆自治区',City=N'吐鲁番地区' WHERE [Pkey] = 400 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(400,N'新疆自治区',N'吐鲁番地区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 401)
UPDATE [TProvinceAndCity] SET Province=N'新疆自治区',City=N'哈密地区' WHERE [Pkey] = 401 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(401,N'新疆自治区',N'哈密地区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 402)
UPDATE [TProvinceAndCity] SET Province=N'新疆自治区',City=N'昌吉回族自治州' WHERE [Pkey] = 402 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(402,N'新疆自治区',N'昌吉回族自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 403)
UPDATE [TProvinceAndCity] SET Province=N'新疆自治区',City=N'博尔塔拉蒙古自治州' WHERE [Pkey] = 403 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(403,N'新疆自治区',N'博尔塔拉蒙古自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 404)
UPDATE [TProvinceAndCity] SET Province=N'新疆自治区',City=N'巴音郭楞蒙古自治州' WHERE [Pkey] = 404 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(404,N'新疆自治区',N'巴音郭楞蒙古自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 405)
UPDATE [TProvinceAndCity] SET Province=N'新疆自治区',City=N'阿克苏地区' WHERE [Pkey] = 405 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(405,N'新疆自治区',N'阿克苏地区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 406)
UPDATE [TProvinceAndCity] SET Province=N'新疆自治区',City=N'克孜勒苏柯尔克孜自治州' WHERE [Pkey] = 406 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(406,N'新疆自治区',N'克孜勒苏柯尔克孜自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 407)
UPDATE [TProvinceAndCity] SET Province=N'新疆自治区',City=N'喀什地区' WHERE [Pkey] = 407 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(407,N'新疆自治区',N'喀什地区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 408)
UPDATE [TProvinceAndCity] SET Province=N'新疆自治区',City=N'和田地区' WHERE [Pkey] = 408 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(408,N'新疆自治区',N'和田地区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 409)
UPDATE [TProvinceAndCity] SET Province=N'新疆自治区',City=N'伊犁哈萨克自治州' WHERE [Pkey] = 409 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(409,N'新疆自治区',N'伊犁哈萨克自治州');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 410)
UPDATE [TProvinceAndCity] SET Province=N'新疆自治区',City=N'塔城地区' WHERE [Pkey] = 410 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(410,N'新疆自治区',N'塔城地区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 411)
UPDATE [TProvinceAndCity] SET Province=N'新疆自治区',City=N'阿勒泰地区' WHERE [Pkey] = 411 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(411,N'新疆自治区',N'阿勒泰地区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 412)
UPDATE [TProvinceAndCity] SET Province=N'新疆自治区',City=N'石河子市' WHERE [Pkey] = 412 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(412,N'新疆自治区',N'石河子市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 413)
UPDATE [TProvinceAndCity] SET Province=N'新疆自治区',City=N'阿拉尔市' WHERE [Pkey] = 413 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(413,N'新疆自治区',N'阿拉尔市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 414)
UPDATE [TProvinceAndCity] SET Province=N'新疆自治区',City=N'图木舒克市' WHERE [Pkey] = 414 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(414,N'新疆自治区',N'图木舒克市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 415)
UPDATE [TProvinceAndCity] SET Province=N'新疆自治区',City=N'五家渠市' WHERE [Pkey] = 415 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(415,N'新疆自治区',N'五家渠市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 416)
UPDATE [TProvinceAndCity] SET Province=N'安徽省',City=N'合肥市' WHERE [Pkey] = 416 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(416,N'安徽省',N'合肥市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 417)
UPDATE [TProvinceAndCity] SET Province=N'安徽省',City=N'芜湖市' WHERE [Pkey] = 417 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(417,N'安徽省',N'芜湖市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 418)
UPDATE [TProvinceAndCity] SET Province=N'安徽省',City=N'蚌埠市' WHERE [Pkey] = 418 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(418,N'安徽省',N'蚌埠市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 419)
UPDATE [TProvinceAndCity] SET Province=N'安徽省',City=N'淮南市' WHERE [Pkey] = 419 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(419,N'安徽省',N'淮南市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 420)
UPDATE [TProvinceAndCity] SET Province=N'安徽省',City=N'马鞍山市' WHERE [Pkey] = 420 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(420,N'安徽省',N'马鞍山市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 421)
UPDATE [TProvinceAndCity] SET Province=N'安徽省',City=N'淮北市' WHERE [Pkey] = 421 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(421,N'安徽省',N'淮北市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 422)
UPDATE [TProvinceAndCity] SET Province=N'安徽省',City=N'铜陵市' WHERE [Pkey] = 422 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(422,N'安徽省',N'铜陵市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 423)
UPDATE [TProvinceAndCity] SET Province=N'安徽省',City=N'安庆市' WHERE [Pkey] = 423 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(423,N'安徽省',N'安庆市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 424)
UPDATE [TProvinceAndCity] SET Province=N'安徽省',City=N'黄山市' WHERE [Pkey] = 424 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(424,N'安徽省',N'黄山市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 425)
UPDATE [TProvinceAndCity] SET Province=N'安徽省',City=N'滁州市' WHERE [Pkey] = 425 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(425,N'安徽省',N'滁州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 426)
UPDATE [TProvinceAndCity] SET Province=N'安徽省',City=N'阜阳市' WHERE [Pkey] = 426 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(426,N'安徽省',N'阜阳市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 427)
UPDATE [TProvinceAndCity] SET Province=N'安徽省',City=N'宿州市' WHERE [Pkey] = 427 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(427,N'安徽省',N'宿州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 428)
UPDATE [TProvinceAndCity] SET Province=N'安徽省',City=N'巢湖市' WHERE [Pkey] = 428 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(428,N'安徽省',N'巢湖市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 429)
UPDATE [TProvinceAndCity] SET Province=N'安徽省',City=N'六安市' WHERE [Pkey] = 429 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(429,N'安徽省',N'六安市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 430)
UPDATE [TProvinceAndCity] SET Province=N'安徽省',City=N'亳州市' WHERE [Pkey] = 430 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(430,N'安徽省',N'亳州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 431)
UPDATE [TProvinceAndCity] SET Province=N'安徽省',City=N'池州市' WHERE [Pkey] = 431 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(431,N'安徽省',N'池州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 432)
UPDATE [TProvinceAndCity] SET Province=N'安徽省',City=N'宣城市' WHERE [Pkey] = 432 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(432,N'安徽省',N'宣城市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 433)
UPDATE [TProvinceAndCity] SET Province=N'浙江省',City=N'杭州市' WHERE [Pkey] = 433 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(433,N'浙江省',N'杭州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 434)
UPDATE [TProvinceAndCity] SET Province=N'浙江省',City=N'宁波市' WHERE [Pkey] = 434 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(434,N'浙江省',N'宁波市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 435)
UPDATE [TProvinceAndCity] SET Province=N'浙江省',City=N'温州市' WHERE [Pkey] = 435 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(435,N'浙江省',N'温州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 436)
UPDATE [TProvinceAndCity] SET Province=N'浙江省',City=N'嘉兴市' WHERE [Pkey] = 436 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(436,N'浙江省',N'嘉兴市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 437)
UPDATE [TProvinceAndCity] SET Province=N'浙江省',City=N'湖州市' WHERE [Pkey] = 437 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(437,N'浙江省',N'湖州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 438)
UPDATE [TProvinceAndCity] SET Province=N'浙江省',City=N'绍兴市' WHERE [Pkey] = 438 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(438,N'浙江省',N'绍兴市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 439)
UPDATE [TProvinceAndCity] SET Province=N'浙江省',City=N'金华市' WHERE [Pkey] = 439 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(439,N'浙江省',N'金华市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 440)
UPDATE [TProvinceAndCity] SET Province=N'浙江省',City=N'衢州市' WHERE [Pkey] = 440 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(440,N'浙江省',N'衢州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 441)
UPDATE [TProvinceAndCity] SET Province=N'浙江省',City=N'舟山市' WHERE [Pkey] = 441 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(441,N'浙江省',N'舟山市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 442)
UPDATE [TProvinceAndCity] SET Province=N'浙江省',City=N'台州市' WHERE [Pkey] = 442 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(442,N'浙江省',N'台州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 443)
UPDATE [TProvinceAndCity] SET Province=N'浙江省',City=N'丽水市' WHERE [Pkey] = 443 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(443,N'浙江省',N'丽水市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 444)
UPDATE [TProvinceAndCity] SET Province=N'福建省',City=N'福州市' WHERE [Pkey] = 444 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(444,N'福建省',N'福州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 445)
UPDATE [TProvinceAndCity] SET Province=N'福建省',City=N'厦门市' WHERE [Pkey] = 445 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(445,N'福建省',N'厦门市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 446)
UPDATE [TProvinceAndCity] SET Province=N'福建省',City=N'莆田市' WHERE [Pkey] = 446 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(446,N'福建省',N'莆田市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 447)
UPDATE [TProvinceAndCity] SET Province=N'福建省',City=N'三明市' WHERE [Pkey] = 447 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(447,N'福建省',N'三明市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 448)
UPDATE [TProvinceAndCity] SET Province=N'福建省',City=N'泉州市' WHERE [Pkey] = 448 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(448,N'福建省',N'泉州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 449)
UPDATE [TProvinceAndCity] SET Province=N'福建省',City=N'漳州市' WHERE [Pkey] = 449 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(449,N'福建省',N'漳州市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 450)
UPDATE [TProvinceAndCity] SET Province=N'福建省',City=N'南平市' WHERE [Pkey] = 450 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(450,N'福建省',N'南平市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 451)
UPDATE [TProvinceAndCity] SET Province=N'福建省',City=N'龙岩市' WHERE [Pkey] = 451 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(451,N'福建省',N'龙岩市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 452)
UPDATE [TProvinceAndCity] SET Province=N'福建省',City=N'宁德市' WHERE [Pkey] = 452 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(452,N'福建省',N'宁德市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 453)
UPDATE [TProvinceAndCity] SET Province=N'台湾省',City=N'台北市' WHERE [Pkey] = 453 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(453,N'台湾省',N'台北市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 454)
UPDATE [TProvinceAndCity] SET Province=N'台湾省',City=N'高雄市' WHERE [Pkey] = 454 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(454,N'台湾省',N'高雄市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 455)
UPDATE [TProvinceAndCity] SET Province=N'台湾省',City=N'基隆市' WHERE [Pkey] = 455 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(455,N'台湾省',N'基隆市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 456)
UPDATE [TProvinceAndCity] SET Province=N'台湾省',City=N'台中市' WHERE [Pkey] = 456 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(456,N'台湾省',N'台中市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 457)
UPDATE [TProvinceAndCity] SET Province=N'台湾省',City=N'台南市' WHERE [Pkey] = 457 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(457,N'台湾省',N'台南市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 458)
UPDATE [TProvinceAndCity] SET Province=N'台湾省',City=N'新竹市' WHERE [Pkey] = 458 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(458,N'台湾省',N'新竹市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 459)
UPDATE [TProvinceAndCity] SET Province=N'台湾省',City=N'嘉义市' WHERE [Pkey] = 459 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(459,N'台湾省',N'嘉义市');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 460)
UPDATE [TProvinceAndCity] SET Province=N'香港',City=N'中西区' WHERE [Pkey] = 460 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(460,N'香港',N'中西区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 461)
UPDATE [TProvinceAndCity] SET Province=N'香港',City=N'湾仔区' WHERE [Pkey] = 461 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(461,N'香港',N'湾仔区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 462)
UPDATE [TProvinceAndCity] SET Province=N'香港',City=N'东区' WHERE [Pkey] = 462 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(462,N'香港',N'东区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 463)
UPDATE [TProvinceAndCity] SET Province=N'香港',City=N'南区' WHERE [Pkey] = 463 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(463,N'香港',N'南区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 464)
UPDATE [TProvinceAndCity] SET Province=N'香港',City=N'油尖旺区' WHERE [Pkey] = 464 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(464,N'香港',N'油尖旺区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 465)
UPDATE [TProvinceAndCity] SET Province=N'香港',City=N'深水埗区' WHERE [Pkey] = 465 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(465,N'香港',N'深水埗区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 466)
UPDATE [TProvinceAndCity] SET Province=N'香港',City=N'九龙城区' WHERE [Pkey] = 466 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(466,N'香港',N'九龙城区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 467)
UPDATE [TProvinceAndCity] SET Province=N'香港',City=N'黄大仙区' WHERE [Pkey] = 467 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(467,N'香港',N'黄大仙区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 468)
UPDATE [TProvinceAndCity] SET Province=N'香港',City=N'观塘区' WHERE [Pkey] = 468 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(468,N'香港',N'观塘区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 469)
UPDATE [TProvinceAndCity] SET Province=N'香港',City=N'荃湾区' WHERE [Pkey] = 469 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(469,N'香港',N'荃湾区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 470)
UPDATE [TProvinceAndCity] SET Province=N'香港',City=N'葵青区' WHERE [Pkey] = 470 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(470,N'香港',N'葵青区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 471)
UPDATE [TProvinceAndCity] SET Province=N'香港',City=N'沙田区' WHERE [Pkey] = 471 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(471,N'香港',N'沙田区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 472)
UPDATE [TProvinceAndCity] SET Province=N'香港',City=N'西贡区' WHERE [Pkey] = 472 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(472,N'香港',N'西贡区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 473)
UPDATE [TProvinceAndCity] SET Province=N'香港',City=N'大埔区' WHERE [Pkey] = 473 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(473,N'香港',N'大埔区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 474)
UPDATE [TProvinceAndCity] SET Province=N'香港',City=N'北区' WHERE [Pkey] = 474 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(474,N'香港',N'北区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 475)
UPDATE [TProvinceAndCity] SET Province=N'香港',City=N'元朗区' WHERE [Pkey] = 475 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(475,N'香港',N'元朗区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 476)
UPDATE [TProvinceAndCity] SET Province=N'香港',City=N'屯门区' WHERE [Pkey] = 476 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(476,N'香港',N'屯门区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 477)
UPDATE [TProvinceAndCity] SET Province=N'香港',City=N'离岛区' WHERE [Pkey] = 477 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(477,N'香港',N'离岛区');

IF EXISTS(SELECT TOP 1 0 FROM [TProvinceAndCity] WHERE [Pkey] = 478)
UPDATE [TProvinceAndCity] SET Province=N'澳门',City=N'澳门' WHERE [Pkey] = 478 ;
ELSE
INSERT [TProvinceAndCity](Pkey,Province,City) VALUES(478,N'澳门',N'澳门');

SET IDENTITY_INSERT TProvinceAndCity OFF ;
ENABLE TRIGGER ALL ON TProvinceAndCity ;
COMMIT TRANSACTION ;

END TRY
BEGIN CATCH
SET IDENTITY_INSERT TProvinceAndCity OFF ;
ENABLE TRIGGER ALL ON TProvinceAndCity ;
ROLLBACK TRANSACTION ;
EXECUTE spThrowCatchedErrorMessage ;
END CATCH