Cannot resolve collation conflict for equal to operation
SQL語句進行left join的時候發生Cannot resolve collation conflict for equal to operation.錯誤
加入database_default就可以了
如LEFT JOIN @CorePartTemp cpt on o.Part = cpt.ProductId COLLATE database_default
加入database_default就可以了
如LEFT JOIN @CorePartTemp cpt on o.Part = cpt.ProductId COLLATE database_default
posted by 小魚 at 9:35 AM
0 Comments:
Post a Comment
<< Home