Cannot resolve collation conflict between "Chinese_*_Stroke_CI_AS" and "Chinese_PRC_CI_AS" in UNION ALL operator occurring in SELECT statement column 1.
Cannot resolve collation conflict between "Chinese_*_Stroke_CI_AS" and "Chinese_PRC_CI_AS" in UNION ALL operator occurring in SELECT statement column 1.
解决方案：
COLLATE Chinese_PRC_CI_AS
例子：
SELECT A.Name FROM A
WHERE A.Code COLLATE Chinese_PRC_CI_AS in （select A_Code COLLATE Chinese_PRC_CI_AS from B ）