Nhieu truong hop khi ban join nhieu Table tu nhieu Database khac nhau co the xay ra loi sau
========
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Vietnamese_CI_AS" in the equal to operation.
=======
How to solve?
======
SELECT
*
FROM dbo.TblTable1
left JOIN dbo.TblTable2 ON
dbo.TblTable1.Item1 COLLATE SQL_Latin1_General_CP1_CI_AS = dbo.TblTable2.Item1
======
Chi can them dong code 'COLLATE SQL_Latin1_General_CP1_CI_AS' vào vi tri nhu dong lenh ben tren la OK
Nguồn: Sharecode.vn