无法在SQL Server 2008中加入表格 [英] Can't join tables in SQL Server 2008

问题描述

您好所有访客
我在sql server 2008中的连接表有问题.
我已经创建了2个表(客户和购买)
这些表通过使用customerCode(在Customer表中为primary)和customerCode(在Purchase表中为Foregn)进行链接.
这是我的查询:

Hi all visitors
i have problem with join tables in sql server 2008.
i have created 2 tables(customer and purchase)
these tables link by using customerCode(primary in Customer Table) and customerCode(Foregn in Purchase Table).
This is my query:

select*
from Customer T0
join Purchase T1 on T0.customercode=T1.customercode

当我执行时，它显示如下错误:

在等于操作中，无法解决"SQL_Latin1_General_CP1_CI_AS"和"Latin1_General_CI_AI"之间的排序规则冲突.

有人知道我如何加入他们吗?

最好的问候，

When i execute, it display error like this:

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

Anybody know how i can join them?

Best Regards,

推荐答案

通过使两个表具有相同的字符集.这就是错误消息的含义.

By making your two tables have the same character set. That''s what the error message means.

一些链接可以帮助解决此问题:

http://blog.sqlauthority .com/2007/06/11/sql-server-cannot-resolve-collat​​ion-conflict-for-equal-to-operation/ [ http://social.msdn.microsoft.com /Forums/zh-CN/sqltools/thread/5b8fe3d4-b338-4c46-a168-943e272e6c17/ [ http://support.microsoft.com/kb/325681 [

Some links to help fix the issue:

http://blog.sqlauthority.com/2007/06/11/sql-server-cannot-resolve-collation-conflict-for-equal-to-operation/[^]
http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/5b8fe3d4-b338-4c46-a168-943e272e6c17/[^]
http://support.microsoft.com/kb/325681[^]

这篇关于无法在SQL Server 2008中加入表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！