sql左连接时发生字符集错误Cannot resolve the collation conflict between in the equal to operation.

SQL语句进行left join的时候发生以下错误：

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Chinese_PRC_CI_AI" in the equal to operation.

加入database_default就可以了
如
LEFT JOIN @table1 cpt on o.Part = cpt.ProductId COLLATE database_default