欢迎投稿

今日深度:

SQL Server like 字段,SQL增加字段

SQL Server like 字段,SQL增加字段


参考资料: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

如果不加这个,就会报错

www.htsjk.Com true http://www.htsjk.com/Sql_Server/38243.html NewsArticle SQL Server like 字段,SQL增加字段 参考资料:Cannot resolve the collation conflict between "Chinese_PRC_CI_AS" and "SQL_L及由于排序规则不同导致查询结果为空的问题 SELECT * FROM dbo.ESysUser eu WHERE et.TypeCode...
相关文章
    暂无相关文章
评论暂时关闭