34,588
社区成员
发帖
与我相关
我的任务
分享
--先来一个全列表
WITH num
as
( SELECT iphone1 AS num
FROM TB
UNION
SELECT iphone2 AS num
FROM TB
UNION
SELECT iphone3 AS num
FROM TB
UNION
SELECT iphone4 AS num
FROM TB
)
--然后判断要插入的是否跟这里个里面有重复
SELECT * FROM #temp WHERE NOT EXISTS(SELECT 1 FROM num WHERE num=#temp.number) --number 是需要导入的号码字段