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

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...