数据库Yoda时候会报排序规则冲突。排序规则不一致,无法直接比较。
解决方式,将其中一种排序规则转换为另一种。(见最后一行) collate Chinese_PRC_90_CI_AI
1 select t1.name,t1.system_type_id,t1.user_type_id,t1.max_length,t2.* from ( 2 select * from test2.sys.columns where object_id=object_id('Sys_Users_History') 3 ) t1 join ( 4 select t2.name tab_name,t1.name,t1.system_type_id,t1.user_type_id,t1.max_length 5 from [10.1.4.234].db_tank.sys.columns t1 6 join [10.1.4.234].db_tank.dbo.sysobjects t2 on t1.object_id=t2.id and t2.name = 'Sys_Users_History' 7 ) t2 on t1.name= t2.name collate Chinese_PRC_90_CI_AI