"Chinese_PRC_CI_AS" 之间的排序规则冲突

消息 468,级别 16,状态 9,第 2 行
无法解决 equal to 运算中 "SQL_Latin1_General_CP1_CI_AS" 和 "Chinese_PRC_CI_AS" 之间的排序规则冲突。

sql = @"SELECT MFCRD_MANUALNO, MFCRDTP_DESC collate  Chinese_PRC_CS_AS_WS AS [MFCRDTP_DESC],
                    MFCRD_NAME collate  Chinese_PRC_CS_AS_WS AS [MFCRD_NAME], MFCRD_REGDATE,
                    MFCRD_EXPIRE FROM MFCRD_TBL LEFT JOIN MFCRDTP_TBL ON MFCRDTP_TYPE = MFCRD_TYPE collate Chinese_PRC_CI_AI_WS {0}";

原文地址:https://www.cnblogs.com/BrianLee/p/2503485.html