SQL: Could not resolve collation violation for equal to operation.

when the stored procedure was changed, there was an "unable to resolve collation violation of equal to Operation" error in SQL, which was found on the web, and the collation was different when elements were created between tables (one is collate chinese_prc_ci_ai_ws, One for collate sql_latin1_general_cp1_ci_as) COLLATE 一个子句，可应用于数据库定义或列定义以定义排序规则，或应用于字符串表达式以应用排序规则投影。General Solutions:You can add collate chinese_prc_ci_ai_ws directly after the associated field of the report. If you add or give an error, try the following options:  1.用 sp_helpdb 库名 2.在status列找到Collation=排序规则 3. select *  fromTable where 列 collate 排序规则  not in ( select 列 collate 排序规则  from DB2.表) 这两个排序规要统一成一个