SQL语句进行left join的时候发生Cannot resolve collation conflict for equal to operation.错误

SQL语句进行left join的时候发生Cannot resolve collation conflict for equal to operation.错误
加入database_default就可以了
如
LEFT JOIN @CorePartTemp cpt on o.Part = cpt.ProductId COLLATE database_default