我有一个sql语句是….

SELECT   ResolverID AS ddlValue,ResolverTeam & ' | ' & ResolverPerson AS ddlText 
FROM     dbo.TblResolvers 
ORDER BY ResolverTeam,ResolverPerson;

当这运行我得到错误：

The data types nvarchar and varchar are incompatible in the boolean
AND operator.

在表中ResolverTeam和ResolverPerson都被指定为(nvarchar(255),null)

为什么我得到这个错误？

解决方法

• 上一篇：sql-server – 我的数据库安全性如下一篇：sql – 仅解除订单语句