Today I try to use Union to join query result of tables of different SQL server (use linked server) and get the following error message
Cannot resolve the collation conflict between "Chinese_PRC_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the UNION operation.
The solution wil be syntax similar as below
WHERE A.Column COLLATE SQL_Latin1_General_CP1_CI_AS = B.Column
(i.e. to override/convert A.column to proper collation)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment