SQL Server JOIN Tables with Different Collation

SQLUSA.com

SQL 2008 GRAND SLAM ON 49 CD

SQL Server Training	SQL 2005 Scripts	SQL 2008	Articles
SQL JOBS	News	Format	Developer

How to join two tables with different collation?

If the tables have different collation you will get an error message if you are using regular JOIN. You have to use the collate clause. It is sufficient to use it on one side. Example:

where PO.InvoiceDetailID = Transmittal.InvoiceDetailID COLLATE SQL_Latin1_General_CP1_CI_AS

where PO.InvoiceDetailID = Transmittal.InvoiceDetailID COLLATE DATABASE_DEFAULT

Order SQL 2008 GRAND SLAM Today!

SQLUSA.com Home Page

SQL Server Training at www.sqlusa.com.
Microsoft SQL Server 2012 Training Videos at www.sqlusa.com.
SQL Server 2008 Video Training at www.sqlusa.com.
SQL Server 2005 Training Videos at www.sqlusa.com.

Accounting
Administrative
Advertising
Arts
Architecture
Banking
Business Intelligence
Career Jobs
Celebrity
Computer
Consulting
Customer Service
Education
Engineering

Entertainment
Entry Level
Executive
Federal
Finance
Government
Hardware
Healthcare
Hospital
Human Resources
Information Technology
Insurance
Internet
Job Openings

Laboratory
Law Enforcement
Legal
Logistics
Manufacturing
Marketing
Medical
Military
Nursing
Pharmaceutical
Physician
Public Relations
Publishing
Real Estate

Restaurant
Retail
Sales
Social Media
Software
SQL Database
Telecomm
Therapist
Training
Transportation
Truck Driver
Travel
Web
Work from Home

FREE SS SQL / BI OLAP Short Videos on YOUTUBE.com

Search SQLUSA FREE SQL Server Articles & FREE T-SQL Scripts

JOIN US ON TWITTER

Copyright 2005-2012, SMI Corp. All Rights Reserved.

SQL Server 2012 is a program product of Microsoft Corporation.
SQL Server 2008 is a program product of Microsoft Corporation.
SQL Server 2005 is a program product of Microsoft Corporation.
SQL Server 2000 is a program product of Microsoft Corporation.