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

来源:互联网 发布:iptv网络电视apk下载 编辑:程序博客网 时间:2024/05/16 17:24


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
原创粉丝点击