如何在SQL Server的JOIN中使用COLLATE? [英] How to use the COLLATE in a JOIN in SQL Server?
本文介绍了如何在SQL Server的JOIN中使用COLLATE?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试联接两个表,但出现此错误:
I´m trying to join two tables but I get this error:
消息468,级别16,状态9,第8行无法解决"SQL_Latin1_General_CP1_CI_AS"和"SQL_Latin1_General_CP1_CI_AS"之间的排序规则冲突 等于操作中的"Latin1_General_CI_AS".
Msg 468, Level 16, State 9, Line 8 Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
这是我正在使用的代码:
This is the code I´m using:
SELECT *
FROM [FAEB].[dbo].[ExportaComisiones] AS f
JOIN [zCredifiel].[dbo].[optPerson] AS p
ON (p.vTreasuryId = f.RFC) COLLATE Latin1_General_CI_AS
我知道这是错误的,它强调了 COLLATE .我不知道如何应用它.
I know it is wrong, it underlines COLLATE. I do not know how to apply it.
推荐答案
正确的语法如下所示.请参见 MSDN .
Correct syntax looks like this. See MSDN.
SELECT *
FROM [FAEB].[dbo].[ExportaComisiones] AS f
JOIN [zCredifiel].[dbo].[optPerson] AS p
ON p.vTreasuryId COLLATE Latin1_General_CI_AS = f.RFC COLLATE Latin1_General_CI_AS
这篇关于如何在SQL Server的JOIN中使用COLLATE?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文