Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the UNION operation.
1、推荐方式创建视图用 COLLATE 方式来解决
CREATE VIEW 视图
AS
SELECT 测试列 COLLATE SQL_Latin1_General_CP1_CI_AS AS 名称
FROM 表
2、不推荐方式修改数据库排序方式(记得备份数据)
USE master;
GO
ALTER DATABASE [数据库] SET OFFLINE WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE [数据库] SET ONLINE
GO
ALTER DATABASE [数据库]
COLLATE SQL_Latin1_General_CP1_CI_AS ;
GO