执行SQL语可异常Cannot resolve the collation conflict between'SQL "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation."
解决:
1.打开SQL server数据库,选中正在使用数据库,右键,属性;
2.在选项里面修改排序规则,改为“chinese_PRC_CI_AS”,修改后保存。
执行SQL语可异常Cannot resolve the collation conflict between'SQL "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation."
解决:
1.打开SQL server数据库,选中正在使用数据库,右键,属性;
2.在选项里面修改排序规则,改为“chinese_PRC_CI_AS”,修改后保存。