修复我的SQL Server 2008 [英] Fix my SQL server 2008

问题描述

将数据类型nvarchar转换为数字时出错。



我尝试过：

Error converting data type nvarchar to numeric.

What I have tried:

select MAX(cast(number_qamema as decimal(15,4))) as NB_QE from DB_DAEN where name_costomer1='waleed'  group by name_costomer1

推荐答案

错误是由您的数据引起的 - 列 number_qanema 无法转换为十进制值。

按如下方式更改查询;

The error is caused by your data - the column number_qanema cannot be converted to a decimal value.
Change your query as follows;

SELECT
    MAX(CAST(number_qamema AS DECIMAL(15,4))) AS NB_QE 
FROM
    NB_QE
WHERE
    ISNUMERIC(number_qamema) = 1
    AND
    name_costomer1 = 'waleed'
GROUP BY
    name_costomer1

亲切的问候

Kind Regards

这篇关于修复我的SQL Server 2008的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！