SQL SERVER 做联合查询时。
遇到 排序规则不匹配。
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Chinese_PRC_CI_AI" in the equal to operation.
加入database_default就可以了
LEFT JOIN @table1 cpt on o.Part = cpt.ProductId COLLATE database_default