Cannot resolve the collation conflict between "Chinese_prc_ci_as" and "sql_l and the problem of NULL query results due to different collation rules

Error: Cannot resolve the collation conflict between "Chinese_prc_ci_as" and "sql_l

Cause of Error:

collation inconsistencies for two cross-library tables

Workaround: Add collate chinese_prc_ci_as after any column name that is faulted

For example:

Use DBA;
INSERT into Subjectdb. Prodefine.projectinfo
(Code,
Projectcitycode,
Cnname,
Creator,
Createtime,
Validstatus,
Sortno,
Versionno,
Versionstarttime
)
SELECT NEWID (),
City. Code,
INS. Project name,
' BDD ',
GETDATE (),
' 1 ',
' 1 ',
' 1 ',
GETDATE ()
From Bdd_projectinfo_shiyan_insert INS
INNER JOIN SUBJECTDB.Common.City cities on INS. Project City COLLATE chinese_prc_ci_as =city. Cnname
WHERE INS. Project name COLLATE chinese_prc_ci_as not in (SELECT cnname
From Subjectdb. Prodefine.projectinfo
 )

Cannot resolve the collation conflict between "Chinese_prc_ci_as" and "sql_l and cause the query result to be empty because of different collation