SQL Server comparison of inter-database fields with different collations

The fields of the different collations cannot be compared directly. Prompt: Unable to resolve collation violation for equal to operation. You can cast a field into a collation so that it can be compared. Example:

--------------------------------------

SELECT *
From Tab1 a left OUTER JOIN
TaB2 u on a.admissionno = U.username COLLATE chinese_prc_ci_as

--------------------------------------

Where TAB2 is a table in another database, a view with the same name is created in this database. This makes it possible to invoke a table in another database as if it were a table in this database. The database where the TAB1 resides is case-insensitive, and the database where the TAB2 resides is case-sensitive. COLLATE Chinese_prc_ci_as casts the collation to case insensitive.

Attached (Chinese database General collation Modification):

COLLATE chinese_prc_ci_as
--Case insensitive
COLLATE chinese_prc_cs_as
--Case sensitive

SQL Server comparison of inter-database fields with different collations