SQL Server Union等操作时解决不同数据库字符集冲突的问题

两个数据库的字符集不同，我们在进行union 等操作时，会出现字符集冲突错误．
例如：
SELECT ISNULL (Report_No,’’) as ReportNo FROM SYSSCAN_WDC_ETS…SR_report_master
UNION
SELECT ISNULL (Report_No ,’’) as ReportNo FROM Inspection…MPI_Master
C

–出现错误：
cannot resolve the collation conflict between “Chinese_Taiwan_Stroke_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the UNION operation.

解决方案，用COLLATE 指定同一个字符集即可：

SELECT ISNULL (Report_No COLLATE SQL_Latin1_General_CP1_CI_AS,’’) as ReportNo FROM SYSSCAN_WDC_ETS…SR_report_master
UNION
SELECT ISNULL (Report_No COLLATE SQL_Latin1_General_CP1_CI_AS,’’) as ReportNo FROM Inspection…MPI_Master