"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/archive/2012/05/16/2503485.html