从数据类型 nvarchar 转换为 numeric 时出错

请排查是不是你把数字类型的数据往字符类型数据库列中写,比如说:

SELECT count(0)
 FROM sys_user u
 LEFT JOIN sys_dept d
 ON u.dept_id = d.dept_id
 WHERE u.del_flag = '0' AND (u.id_branch = 15866666548);

改成

SELECT count(0)
 FROM sys_user u
 LEFT JOIN sys_dept d
 ON u.dept_id = d.dept_id
 WHERE u.del_flag = '0' AND (u.id_branch = '15866666548');