SQL Server like 字段

2022-06-14 11:38:42

参考资料：Cannot resolve the collation conflict between "Chinese_PRC_CI_AS" and "SQL_L及由于排序规则不同导致查询结果为空的问题

SELECT * FROM dbo.ESysUser eu WHERE et.TypeCode LIKE ‘%‘+ eu.UserType +‘%‘  COLLATE database_default

注意：COLLATE database_default

如果不加这个，就会报错

SQL Server like 字段

上一篇：mysql从5.6升级到5.7后出现 Expression #1 of ORDER BY clause is not in SELECT list,this is incompatible with DISTINCT


下一篇：Linux系统上数据库管理和开发工具DBeaver使用安装介绍