sql-server - SQL Server : How to treat nulls as zeros

Question

这是我正在尝试做的事情的示例:

Select
S1.Name as S1Name,
S1.Itemcontent as S1ItemContent,
...
S2.Name as S2Name,
S2.Name as S2ItemContent,
**(S1.OrderValue * 1000*1000 + S2.OrderValue*1000 +  S3.OrderValue) as OrderValue**
From (joining s1, s2 and s3 on a particular value)
Order by OrderValue

当 S1.OrderValue、S2.OrderValue 或 S3.OrderValue 为 null 时，OrderValue 也变为 null。在这种情况下，我希望 SQL Server 将空值视为 0。我该怎么做？

Answer 1

使用isNull函数，如

isnull(s1.ordervalue,0)

如果该值为空，它将使用您提供的替代值作为第二个值。