参考了解决办法: Cannot resolve the collation conflict between "Japanese_CI_AS" and "SQL_...
select * from #PlanLineLoadingA m where exists (select t.Prefix from #Vw_EXTERNAL_MT_Pattern t where Comp_Code='VN' and m.Prefix=t.Prefix )
报错
加了 COLLATE database_default 就可以了
select * from #PlanLineLoadingA m where exists (select t.Prefix from #Vw_EXTERNAL_MT_Pattern t where Comp_Code='VN' and m.Prefix=t.Prefix COLLATE database_default )