ErrorMessage

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

查看SQL Server的Collation

SELECT SERVERPROPERTY ('Collation')

Solution

1. 在安裝SQL Server的時候Collation都選擇Latin1_General（拉丁，不帶100的那個）

2. 如果已經安裝了SQL Server的話，那就在Database的屬性下修改吧

轉載于:https://www.cnblogs.com/chenyongblog/p/4382125.html

總結

以上是生活随笔為你收集整理的Cannot resolve the collation conflict between SQL_Latin1_General_CP1_CI_AS and Latin1_General_100...的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。