Cannot resolve the collation conflict between "Chinese_prc_ci_as" and "sql_latin1_general_cp1_ci_as" in the equal to opera tion.

Error:

MSG 468, Level 16, State 9, procedure XXXX, line No. 355
Cannot resolve the collation conflict between "Chinese_prc_ci_as" and "sql_latin1_general_cp1_ci_as" in the equal to opera tion.

Solution:

Original statement (Error):

SELECT
A.shopno as DEPTCD, C.[shopcnname] as Deptname,a.todaydate,
SUM (TotalAmount) as Amount
From
#abc A
INNER JOIN dbo. Paymentmaster b on A.tenderno=b.[paymentno]
INNER JOIN dbo. Shopmaster C on A.[shopno]=c.[shopno]

Correct statement after modification:

SELECT
A.shopno as DEPTCD, C.[shopcnname] as Deptname,a.todaydate,
SUM (TotalAmount) as Amount
From
#abc A
INNER JOIN dbo. Paymentmaster b on A.tenderno=b.[paymentno]
INNER JOIN dbo. Shopmaster c on A.[shopno]=c.[shopno] collate chinese_prc_ci_as

Description

Http://msdn.microsoft.com/zh-cn/library/ms184391.aspx

Third, the solution

1. Change the field of one table in the database to the same collation as the field that you want to compare in the other table.

2. Add a SQL fragment like this after the WHERE clause of the SQL statement: Collate CHINESE_PRC_CI_AI_WS

Such as:

Select a.* from a b Where a.a = b.b Collate Chinese_prc_ci_ai_ws

http://blog.csdn.net/xiuhaijuanqiang/article/details/9966379

Cannot resolve the collation conflict between "Chinese_prc_ci_as" and "sql_latin1_general_cp1_ci_as" in the equal to opera tion.