Sql server中Collation conflict問題

SQL語句查詢時
select A.Code,A.Name,a.Systemcode,B.ID,B.LogType,B.DMCode,B.IP,B.Department,B.CreateBy,B.CreateTime
from DM_Document_TD as A left join DM_LOG_TD as B
on A .Code=B .DMCode 

結果在運行時碰到這樣一個問題，問題描述：
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Chinese_PRC_CI_AS" in the equal to operation.
到網上搜了一下，瞭解了問題產生的原因，原來是兩個資料庫的collation不一致導致的，將查詢語句改成如下：

select A.Code,A.Name,a.Systemcode,B.ID,B.LogType,B.DMCode,B.IP,B.Department,B.CreateBy,B.CreateTime
from DM_Document_TD as A left join DM_LOG_TD as B
on A .Code collate chinese_prc_ci_as =B .DMCode