CODE EXAMPLE FOR SQL

How to fix a collation conflict in a SQL Server query

# You can resolve the issue by forcing the collation used in a query to be a particular
# collation, e.g. SQL_Latin1_General_CP1_CI_AS or DATABASE_DEFAULT. For example:

SELECT MyColumn
FROM FirstTable a
INNER JOIN SecondTable b
ON a.MyID COLLATE SQL_Latin1_General_CP1_CI_AS = 
b.YourID COLLATE SQL_Latin1_General_CP1_CI_AS