Monday, 31 December 2018

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

//////////////


select * from [DBName].[dbo].[tableName_1] t inner join [DBName].[dbo].[tableName_2]  b on a.ColumnName COLLATE DATABASE_DEFAULT =b.ColumnName COLLATE DATABASE_DEFAULT

No comments:

Post a Comment

How to highlight selected text in notepad++

  –> To highlight a block of code in Notepad++, please do the following steps step-1  :- Select the required text. step-2  :- Right click...