The collation of the value is not resolved because of a collation violation between UNION all Chinese_prc_ci_as

Because the collation differs between the different tables, there is a sort problem when merging the collections.

Simply declare the collation of the resulting column after the column of the query to be consistent:

SELECT B0. [Cardcode] Collate sql_latin1_general_cp850_ci_as as Id, B0.  [Docentry] As OrderId, B0. [Numatcard] Collate sql_latin1_general_cp850_ci_as as customerno,b0.  [Docdate] As Ordertime
From  table

Data column for string literal type!!!!!!!!!

The collation of the value is not resolved because of a collation violation between UNION all Chinese_prc_ci_as