今天在连接查询两个表时,总是提示
Cannot resolve the collation conflict between "Chinese_PRC_CI_AS" and "Chinese_Taiwan_Stroke_CI_AS" in the equal to operation
这时只需统一一下要比较的两个字段的字符排序规则即可
列:select *
from A
where exists
(
select *
from B
where A.Link_Id = B.link_id and charindex(A.link_ids collate Chinese_Taiwan_Stroke_CI_AS,B.link_ids collate Chinese_Taiwan_Stroke_CI_AS) > 0
)