SQL SERVER ERROR: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation

Question

Msg 468, Level 16, State 9, Line 26
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.

Answer 1

Use the following command and resolve the above issue. DATABASE_DEFAULT i.e

update [TableName] set
    [ColumnName] = [i.ColumnName]
from [TableName] i
where i.[ColumnName] COLLATE DATABASE_DEFAULT = [TableName].[ColumnName] COLLATE DATABASE_DEFAULT