SQL Server : 排序规则冲突-collate Chinese_PRC_90_CI_AI

 数据库Yoda时候会报排序规则冲突。排序规则不一致，无法直接比较。

 解决方式，将其中一种排序规则转换为另一种。（见最后一行） collate Chinese_PRC_90_CI_AI 

select t1.name,t1.system_type_id,t1.user_type_id,t1.max_length,t2.* from (
select * from test2.sys.columns where object_id=object_id('Sys_Users_History')
) t1 join (
select t2.name tab_name,t1.name,t1.system_type_id,t1.user_type_id,t1.max_length
from [10.1.4.234].db_tank.sys.columns t1 
join [10.1.4.234].db_tank.dbo.sysobjects t2  on t1.object_id=t2.id and t2.name = 'Sys_Users_History'
) t2 on t1.name=  t2.name collate Chinese_PRC_90_CI_AI