SQL Server 2000 DTS - 无法解决等于操作的排序规则冲突 [英] SQL Server 2000 DTS - Cannot resolve collation conflict for equal to operation

问题描述

我有一个 SQL Server 2000 DTS 包.

I have a SQL Server 2000 DTS package.

这个包的其中一个步骤有如下SQL:

One of the steps of this package has the following SQL:

SELECT *
FROM [Crocus_Limited$OrderRequestDetail]
WHERE (rep_updated > GETDATE() -2) 
AND NOT EXISTS

(SELECT OrderID 
FROM NavisionUpgrade.navision4.dbo.[WEBOrderDetails] rd 
WHERE rd.OrderID =     [Crocus_Limited$OrderRequestDetail].OrderID 
AND rd.NavisionItemNo = [Crocus_Limited$OrderRequestDetail].NavisionItemNo )

它失败了 - 给我错误:无法解决 equal to 操作的排序规则冲突.

It is failing- giving me error: cannot resolve collation conflict for equal to operation.

这个 DTS 基本上将数据从一个数据库移动到另一个(位于不同的地理位置)

This DTS basically moves data from one DB to another (located in different geographical locations)

如何更改上述查询以解决此问题?

how can i alter the above query to resolve this?

推荐答案

您的一个或两个连接列具有一种 char 数据类型 (char,nchar,varchar,nvarchar)，这些数据类型存储在每个数据库中不兼容的排序规则中.

One or both of your join columns has on of the char datatypes (char,nchar,varchar,nvarchar) which is stored in incompatible collations in each database.

您可以指定在任何字符串比较中使用的排序规则.最简单的方法是指定运行查询的机器的默认排序规则(我猜 NavisionItemNo 是问题列):

You can specify the collation to use in any string comparison. The easiest way to do it is to specify the default collation of the machine on which the query is running (I'm guessing that NavisionItemNo is the problem column):

...AND rd.NavisionItemNo collate database_default = [Crocus_Limited$OrderRequestDetail].NavisionItemNo collate database_default )

编辑

OrderID 也是 varchar 列吗?如果是这样，请尝试

Is OrderID a varchar column too? If so, try

...WHERE rd.OrderID collate database_default = [Crocus_Limited$OrderRequestDetail].OrderID collate database_default
AND rd.NavisionItemNo collate database_default = [Crocus_Limited$OrderRequestDetail].NavisionItemNo ) collate database_default

这篇关于SQL Server 2000 DTS - 无法解决等于操作的排序规则冲突的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！