22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT * from dbo.VW_msSyInfo_zy
WHERE syh collate Chinese_PRC_CI_AS not in (select Syh from dbo.msSyInfo_zy)
and indate >'2015-01-01'
无法解决 equal to 运算中 "Chinese_PRC_CI_AS" 和 "Chinese_PRC_BIN" 之间的排序规则冲突。
SELECT * from dbo.VW_msSyInfo_zy
WHERE syh not in (select Syh collate Chinese_PRC_BIN from dbo.msSyInfo_zy)
and indate >'2015-01-01'