如何以十进制值而不是空值来获取它 [英] How to get this in decimal value instead of null

问题描述

我正在尝试在此查询中以十进制获取值，但无法获取我正在获取 NULL 值

i am trying to get value in Decimal in this query but unable to get i am getting NULL Value

SELECT CAST(CAST(CAST(SUM(CAST(0 AS INT)) AS DECIMAL(10, 2)) * 100 
/ CAST(NULLIF(SUM(CAST(0 AS INT)) 
+ SUM(CAST(0 AS INT)) + 
SUM(CAST(0 AS INT)), 0)
 AS DECIMAL(10, 2)) AS DECIMAL(10, 2)) AS DECIMAL)

如何获得输出

0.00

在这个查询中代替 null

instead of null in this query

推荐答案

使用 ISNULL 内置函数:

Use ISNULL built in function:

ISNULL(CAST(CAST(CAST(SUM(CAST(0 AS INT)) AS DECIMAL(10, 2)) * 100 / CAST(NULLIF(SUM(CAST(0 AS INT)) + SUM(CAST(0 AS INT)) + SUM(CAST(0 AS INT)), 0) AS DECIMAL(10, 2)) AS DECIMAL(10, 2)) AS DECIMAL), 0) 

http://technet.microsoft.com/es-es/library/ms184325.aspx

这篇关于如何以十进制值而不是空值来获取它的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！