Synear_API/sql/号码归属...

SELECT * INTO T_Sys_MobileData_20190826 FROM dbo.T_Sys_MobileData

--号码段归属地 - 数据更新 - 15614650809 0574    0574 浙江-宁波	联通130卡用户 -> 0531 山东 济南  中国联通
IF EXISTS (SELECT 1 FROM dbo.T_Sys_MobileData where F_MobileNum = '1561465' AND F_ZipCode = '0574')
BEGIN
	UPDATE dbo.T_Sys_MobileData SET F_ZipCode = '0531',F_CityDes = '山东-济南',F_CardDes = '中国联通' WHERE F_MobileNum = '1561465'
END

--号码段归属地 - 数据更新 - 17324811889  0396	河南 驻马店市 电信173卡  -> 0371 河南 郑州  中国电信
IF EXISTS (SELECT 1 FROM dbo.T_Sys_MobileData where F_MobileNum = '1732481' AND F_ZipCode = '0396')
BEGIN
	UPDATE dbo.T_Sys_MobileData SET F_ZipCode = '0371',F_CityDes = '河南-郑州',F_CardDes = '中国电信' WHERE F_MobileNum = '1732481'
END

--号码段归属地 - 数据添加 17539834958 19844999375 17630723821
IF  NOT EXISTS (SELECT 1 FROM dbo.T_Sys_MobileData where F_MobileNum = '1753983')
BEGIN
	INSERT INTO dbo.T_Sys_MobileData
	        ( F_MobileNum ,
	          F_ZipCode ,
	          F_CityDes ,
	          F_CardDes ,
	          F_CreateUser ,
	          F_CreateTime ,
	          F_IsDelete ,
	          F_DeleteUser ,
	          F_DeleteTime
	        )
	VALUES  ( '1753983' , -- F_MobileNum - varchar(20)
	          '0373' , -- F_ZipCode - varchar(10)
	          '河南 新乡' , -- F_CityDes - varchar(50)
	          '中国联通' , -- F_CardDes - varchar(50)
	          '8000' , -- F_CreateUser - varchar(50)
	          '2019-09-10 03:12:38' , -- F_CreateTime - datetime
	          0 , -- F_IsDelete - int
	          NULL , -- F_DeleteUser - varchar(50)
	          NULL  -- F_DeleteTime - datetime
	        )
END

IF  NOT EXISTS (SELECT 1 FROM dbo.T_Sys_MobileData where F_MobileNum = '1984499')
BEGIN
	INSERT INTO dbo.T_Sys_MobileData
	        ( F_MobileNum ,
	          F_ZipCode ,
	          F_CityDes ,
	          F_CardDes ,
	          F_CreateUser ,
	          F_CreateTime ,
	          F_IsDelete ,
	          F_DeleteUser ,
	          F_DeleteTime
	        )
	VALUES  ( '1984499' , -- F_MobileNum - varchar(20)
	          '0319' , -- F_ZipCode - varchar(10)
	          '河北 邢台' , -- F_CityDes - varchar(50)
	          '中国移动' , -- F_CardDes - varchar(50)
	          '8000' , -- F_CreateUser - varchar(50)
	          '2019-09-10 03:12:38' , -- F_CreateTime - datetime
	          0 , -- F_IsDelete - int
	          NULL , -- F_DeleteUser - varchar(50)
	          NULL  -- F_DeleteTime - datetime
	        )
END

IF  NOT EXISTS (SELECT 1 FROM dbo.T_Sys_MobileData where F_MobileNum = '1763072')
BEGIN
	INSERT INTO dbo.T_Sys_MobileData
	        ( F_MobileNum ,
	          F_ZipCode ,
	          F_CityDes ,
	          F_CardDes ,
	          F_CreateUser ,
	          F_CreateTime ,
	          F_IsDelete ,
	          F_DeleteUser ,
	          F_DeleteTime
	        )
	VALUES  ( '1763072' , -- F_MobileNum - varchar(20)
	          '0373' , -- F_ZipCode - varchar(10)
	          '河北 新乡' , -- F_CityDes - varchar(50)
	          '中国联通' , -- F_CardDes - varchar(50)
	          '8000' , -- F_CreateUser - varchar(50)
	          '2019-09-10 03:12:38' , -- F_CreateTime - datetime
	          0 , -- F_IsDelete - int
	          NULL , -- F_DeleteUser - varchar(50)
	          NULL  -- F_DeleteTime - datetime
	        )
END