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

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